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

118 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
comether153725(None) 
comethers1637441comethers
comelier12310652comelier
comember1644162comember
cometh134811682cometh__
couther123914632co_uther
coveter122912062covet_er
together1243742together
aether94213673__aether
ammeter1148393ammet_er
biometer1239603biomet_er
blether12459913_blether
bother115218063bo__ther
cameleer1246033cameleer
cementer1239193cementer
cemetery1554923cemet_ery
cither114616683c__ither
coacher143714123co_acher
coaster94219043coast_er
coater84329573co_at_er
coauthor1343463coauthor
coercer1138383co_ercer
coherer122912783cohe_rer
cointer93616723coint_er
coleader1139183coleader
colter84625093co_lt_er
comaker153410603com_aker
comate104124843comat_e_
comates114123643comat_es
combater1439383combater
comber125118503com__ber
combiner14259723combiner
comedies13311843comedies
comembers1744223comembers
comer95832693com___er
comet95946073comet___
cometary1547693cometary
cometic131215723comet_ic
comets105823583comet__s
comfier1439163com_fier
comities12317793comities
commencer17147803commencer
commender16167923commender
commenter151410693commenter
commoner142710633commoner
communer14349303communer
commuter143010153commuter
comparer143611363comparer
compeer133811553com_peer
compeller1546293compeller
compete134716553compet_e_
competed154113593compet_ed
competes144117243compet_es
compiler1438373compiler
completer153310413complet_er
complier14310253complier
composer145012953composer
compted143813523compt_ed
computer144511513computer
comte96125473com_t_e_
comtes106222813com_t_es
cooter85128613co_ot_er
copter109822013co_pt_er
cosher114819903co__sher
coster84331293co_st_er
cotter84926673co__tter
cottier93814173co_ttier
coucher144515853co_ucher
cougher133711733co_ugher
coulter94115603coult_er
counter94220153count_er
courter94516483court_er
courtier1059333courtier
couter84930223co_ut_er
couthier13218913co_uthier
coverer123113523cove_rer
coveted133011523covet_ed
coveters132411083covet_ers
cozener18328953coze_ner
cryometer1646433cryomet_er
diether1147443_diether
dimeter10411893dimet_er
ether84518773___ether
fomenter1339263fomenter
geometer1138423geomet_er
godmother1642693godmother
homelier1338983homelier
homeotherm2053603homeotherm
loather103711003lo_ather
meter75130323__met_er
metier83517693__metier
mither114218563__mither
mother113718643__mother
mouther123812813mo_uther
nether94014163__nether
norther1039733no_rther
nother93815963no__ther
odometer1147413odomet_er
omitter9298503_omitter
orometer10310703oromet_er
other84219103_o__ther
picometer1548913picomet_er
pother113818853po__ther
scouther1356943sco_uther
smoother13196673smoother
smother123510213_smother
somewhen1642283somewhen
somewhere1742483somewhere
soother104215043so_other
souther104116303so_uther
teether10349693_teether
tether93716103__tether
tother94117143to__ther
udometer1146333udomet_er
untether1145163untether
vomiter1237953vomit_er
wether123315393__wether
whether16346623_whether

Search took 8 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.423422437.4
2DLD Change Limit1461621187.03020791.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.49923828.6
 
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.