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 “comelier” 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.

196 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
comelier1231065(None) 
complier14310251complier
homelier1338981homelier
cameleer1246032cameleer
coalier93416182co_alier
collier93618152co_llier
comedies13311832comedies
comeliest13410032comeliest
comelily1546692comelily
comember1644162comember
comether1537252comether
comfier1439162com_fier
compeller1546292compeller
compiler1438372compiler
complied1539672complied
compliers1538292compliers
complies14314522complies
costlier1038522costlier
hotelier1137632hotelier
lonelier838002lonelier
lovelier1136432lovelier
sommelier1343642sommelier
timelier1036712timelier
atelier7311623_atelier
belier84423563__belier
cameleers1345093cameleers
camelia11510433cameli_a
camelias12510303camelias
camelid1249413cameli_d
camelids1356943camelids
campier133313273cam_pier
cavalier1348173cavalier
ceiler84013963c__eiler
cementer1239193cementer
cheekier1735103cheekier
cheerier1348003cheerier
cheesier1335963cheesier
chewier1537583c_hewier
chillier13328423chillier
cicelies1269753cicelies
coaler84121713co_al_er
cobbier133410163co_bbier
cobbler133311823cobbl_er
cockier154013623co_ckier
coddler113710833coddl_er
codifier1447163codifier
coeliac1138233co_eliac
coercer1138383co_ercer
coheir1137583cohe_i_r
coherer122912783cohe_rer
coholder1436063coholder
coiler84421593co_il_er
cokelike1336813cokelike
colder95121843co__lder
coleader1139173coleader
colies84837053co__lies
colleger11227923colleger
collider113410413co_llider
collie83621993co_llie_
collied103316673co_llied
colliers103613583co_lliers
colliery13307363co_lliery
collies94326583co_llies
colter84625093co__lter
comaker153410603com_aker
combater1439383combater
comber125118503com__ber
combiner14259723combiner
comblike1846293comblike
comedian1347453comedian
comedic14158633comedi_c
comeliness1446993comeliness
comely134213733comel__y
comembers1744223comembers
comer95832693com___er
comethers1637443comethers
cometic131215723cometi_c
comities12317793comities
commencer17147803commencer
commender16167923commender
commenter151410693commenter
commie124215523com_mie_
commies133718453com_mies
commoner142710633commoner
communer14349303communer
commuter143010153commuter
comparer143611363comparer
compeer133811553com_peer
compelled1646133compelled
compellers1645193compellers
compile13312443compile_
compiled1537813compiled
compilers1537053compilers
compiles14311983compiles
complainer1645693complainer
completer153310413completer
complex2037243compl_ex
complexer22316203complexer
complice1639333complice
complices1739253complices
complin13312073compli_n
compline14313553compline
complines15312833complines
complins14313103complins
composer145012953composer
computer144511513computer
cooler84824713co_ol_er
coolie83821603co_olie_
coolies93824963co_olies
copier103722893co__pier
corkier133114303co_rkier
cornier93017093co_rnier
coruler9311713corul_er
cosier84423753co__sier
coterie9417403coterie_
coteries10422703coteries
cottier93814173co_ttier
coulter94115603co_ulter
coupler114713013coupl_er
courier93617893co_urier
courtier1059333courtier
courtlier1154463courtlier
couthier13218913couthier
coverer123113523cove_rer
coveter122912063cove_ter
cowier113616163co__wier
cozener18328953coze_ner
cozier173315143co__zier
crawlier13216873crawlier
creepier1236253creepier
crepier1139733c_repier
crueler939023cruel_er
crueller1056453crueller
crumblier1543873crumblier
crumplier1543783crumplier
cuddlier1234013cuddlier
cupeler1177483cupel_er
cupeller1256103cupeller
curlier93314183c_urlier
cutesier1045623cutesier
dimplier1336673dimplier
domelike15177753domelike
eelier64216463__eelier
fomenter1339263fomenter
gaselier946963gaselier
godlier938893go_dlier
gogglier1153923gogglier
goodlier1035793goodlier
holier94921623ho__lier
homeliest1448553homeliest
homelike17179533homelike
homier116416993hom__ier
homilies132710113homilies
hoteliers1245803hoteliers
jollier142911003jo_llier
jowlier17327563jo_wlier
likelier1235283likelier
livelier1136873livelier
lordlier935363lordlier
loudlier934953loudlier
lovelies1139893lovelies
lowlier10338903lo_wlier
mealier93015903__mealier
melder93915813__melder
melter83520113__melter
metier83517693__metier
modeler1039293model_er
modeller1136613modeller
motlier92010583mo_tlier
novelizer2144703novelizer
oilier64417233_o_ilier
omelet8317073_omel_et
onerier7311613_onerier
outlier72216143_outlier
pimplier1445413pimplier
portlier1038373portlier
relier65826183__relier
roilier7311523ro_ilier
rumplier1235303rumplier
seemlier1035193seemlier
smeller94212783_smeller
smellier1036793_smellier
smelter93311913_smelter
sommeliers1442673sommeliers
steelier839183steelier
towerier1137123towerier
wamblier15275733wamblier
wifelier1434853wifelier
wiselier1137363wiselier
wobblier15325203wobblier
womanlier1443323womanlier
wombier1436543wom_bier
woolier103612353wo_olier
woollier1155433woollier
yodeler1136343yodel_er
yodeller1244853yodeller

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621966.61022112.3
3Display Results1961960.0762578.9
 (SQL Overall)1786911966.85926052.0
 
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.