Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “romajis” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
romajis163591(None) 
romaji1534891romaji_
romanise10312132romanise
romanos94311482romanos
romans84620242roma_ns
rumakis1335532rumakis
aromas81018613aroma__s
aromatic12315643aromatic
aromatics13410903aromatics
bonacis11310323bonacis
bromals1139743broma_ls
bromates12413143bromates
coatis85122603co_atis
comakes154413643comakes
comas95833003coma__s
comates114123643comates
comatic131816943comatic
comatik15139723comatik
comatiks16148043comatiks
domain9511323doma_in
domains10510873domains
fromages1437073fromages
gomutis1035733gomutis
hajis156716283__hajis
homages131011593homages
kojis16468443ko__jis
komatik12135203komatik
komatiks13134013komatiks
mavis105622723__mavis
maxis145721563__maxis
nomadic1248033nomadic
nomadism1346403nomadism
nomads94711603noma_ds
nomas74726413noma__s
oasis56422553_o_asis
okapis1235393_okapis
ooralis7312553ooralis
oxalis1339223_oxalis
pomaces132712123pomaces
pomades123711733pomades
protasis102411973protasis
ragis66325603r__agis
rais45252623r__a_is
rajas127317723r__ajas
rajes125022783r__ajes
rakis95323443r__akis
ramadas1039303ramadas
ranis55235833r__anis
remail85017123rema_il
remails94714563remails
remain85919863rema_in
remains94117913remains
remakes134116173remakes
remands104914883remands
remans84823003rema_ns
remaps105012873rema_ps
remarks13329983remarks
remates93827113remates
roadie72813813ro_adie
roadies83317443ro_adies
roads66523623ro_a_ds
roamers93713463roamers
roams74919613ro_a_ms
roans54926443ro_a_ns
roars55622243ro_a_rs
roasts64915413ro_asts
robalos937683robalos
robands10219863robands
romaine9512123romaine
romaines10512523romaines
roman75424823roma__n
romance11311083romance
romances12310793romances
romanised1247923romanised
romanises11311573romanises
romanize19311013romanize
romanizes20310933romanizes
romano84912943roma_no
romantic1249243romantic
romantics1346783romantics
romaunt947803romaunt
romaunts1043693romaunts
romeos84013173rom_eos
rompers113412243rompers
rompish1436693rom_pish
romps94617543rom__ps
roms67038963rom___s
rosaria749253rosaria
rosaries8312783rosaries
roshis9311793ro_shis
rotaries8315693rotaries
rotas54827723rota__s
rotates72819773rotates
rotis56327063ro__tis
rowans95715343rowa_ns
royalism13128473royalism
royalist111311983royalist
royals93711263roya_ls
rumaki1235133rumaki_
somans84619303soma_ns
somas76030373soma__s
somatic111916473somatic
souaris7312333souaris
tamaris9413603tamaris
tomans85419133toma_ns
umamis1038273_umamis
womanise1348733womanise
womanish1646823womanish
womanism1548113womanism
womanist13410433womanist
womans114613653woma_ns
zombis1936283zom_bis

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271126.08022043.9
3Display Results1121120.0432604.7
 (SQL Overall)1786911126.52927368.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.