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

265 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
commend14401018(None) 
command14399211command
commends15308461commends
comment1310317701comment
compend144010301compend
combed135516542combe_d
commando15275752commando
commands15318822commands
commence16149102commence
commenced18157132commenced
commendam1544952commendam
commended17137012commended
commender16167922commender
commented16129612commented
comments142913882comments
common12310802common_
commons13311042commons
commune13329362commune
communed15338212communed
comped135919872compe_d
compends15378252compends
contend103511892contend
cowmen13810922cowmen_
recommend1664322recommend
tommed113310142tomme_d
amend85717753__amend
bammed133913243bamme_d
bombed134113873bombe_d
bookend14396643bookend
boomed115318133boome_d
bowmen1399853bowmen_
bummed134211723bumme_d
cabmen123610653cabmen_
calmed114816383calme_d
camped134720233campe_d
carmen104019343carmen_
cement103321663c_ement
chimed145814833chime_d
chomped17329773chompe_d
chummed17396443chumme_d
clammed14369963clamme_d
clement11313773clement
clomped14398973clompe_d
coagent10313983coagent
coaled95022713coale_d
coaming123818323coaming
coated94927043coate_d
coattend1134653coattend
coaxed165612513coaxe_d
cocked155022563cocke_d
codded114515303codde_d
coded95433183co_de_d
coden86128543co_den_
codens94821013co_dens
coed77140543co__e_d
coextend1842483coextend
cofound1335513cofound
cogent9321003co_gent
cogged116416613cogge_d
cohead123811123co_head
coifed124113063coife_d
coigned11418663coigned
coiled95123943coile_d
coined94523603coine_d
coked124730693co_ke_d
colead94114643co_lead
coled85540763co_le_d
columned1334923columned
comae97128423comae__
combe116223543combe__
comber125118503combe_r
combers134516623combers
combes125321733combe_s
combine133014723combine
combined15269183combined
combing143714733combing
come87547703co_me__
comedo11359603co_medo
comedy14378233co_medy
comely134213733co_mely
comer95832693co_me_r
comers105328083co_mers
comes97246993co_me_s
comet95946073co_me_t
cometh134811683co_meth
comets105823583co_mets
coming114225453co_ming
comma114514793comm__a
commanded17136503commanded
commander16127403commander
commandos16245963commandos
commas124814573comm_as
commata1338483commata
commencer17147803commencer
commences17139583commences
commendams1644303commendams
commenders17137143commenders
commending1846633commending
commensal1546013commensal
commenter151410693commenter
commerce16116323commerce
commerced18125463commerced
commie124215523comm_ie
commies133718453commies
commit124016703comm_it
commits133812383commits
commix19407763comm_ix
commixed2264743commixed
commixt20357623commixt
commode1438123commode
commoner142710633commoner
commonly1744963commonly
commove1635963commove
commoved1844763commoved
communal1446353communal
communard1644153communard
communer14349303communer
communes143411243communes
commute134310443commute
commuted15288983commuted
commy144712643comm__y
company1619711143company
compeer133811553compeer
compel124412893compe_l
compels133210883compels
compendia1643953compendia
compere134616623compere
compered153414923compered
compete134716553compete
competed154113593competed
comping143518593comping
compone136517193compone
compony1613011913compony
compound1555993compound
compted143813523compted
comte96125473comte__
comtes106222813comte_s
concent114422513concent
coned86040053co_ne_d
congeed113212313congeed
conked135019113conke_d
conned95119703conne_d
consent93723113consent
contends112810573contends
content94326153content
convene123314323convene
convened143412223convened
convent123919413convent
cooed84534343co_oe_d
cooeed95917863co_oeed
cooked135921363cooke_d
cooled95224593coole_d
cooped114821603coope_d
coped105036843co_pe_d
copen94826433co_pen_
copens106119963co_pens
copied114618563copie_d
copped135221253coppe_d
corded105923353corde_d
cored85044223co_re_d
corked135020783corke_d
cormel103815603corme_l
cormels113813373cormels
cormoid12310403cormoid
corned95224523corne_d
coshed124217543coshe_d
cosied94819883cosie_d
cosmid11810643cosm_id
costed95623113coste_d
coted85033853co_te_d
couped115019313coupe_d
coved115027373co_ve_d
coven106925043co_ven_
covens114919263co_vens
cowbind1536613cowbind
cowed115637853co_we_d
cowhand1665933cowhand
cowherd1636953cowherd
cowled125218393cowle_d
cowman13910373cowman_
coxed154322813co_xe_d
coyed114623803co_ye_d
cozen165019703co_zen_
cozened19349183co_zened
cozens176314923co_zens
cozied184112153cozie_d
crammed143710123cramme_d
culmed114610593culme_d
cummer124414593cumme_r
cummers133713483cummers
cummin1288783cummin_
cummins1358963cummins
cymene1377393c_ymene
dammed124214793damme_d
dimmed124110323dimme_d
discommend1853613discommend
dolmen93911373dolmen_
dolmens10388693dolmens
domed95423263do_me_d
doomed104113293doome_d
emend86214893__emend
foamed126014403foame_d
foemen11310523foemen_
foment113718303fo_ment
forfend1435413forfend
formed125021173forme_d
gammed124216163gamme_d
gemmed12329573gemme_d
glommed13265443glomme_d
godsend1084043godsend
gormand1157453gormand
gormed105013833gorme_d
gummed123811663gumme_d
hammed144116973hamme_d
hemmed144211463hemme_d
homed115425423ho_me_d
hummed144812673humme_d
impend11478793_impend
jammed183811503jamme_d
lammed113915623lamme_d
loamed94414613loame_d
loment84021473lo_ment
loomed94616763loome_d
mend75334033___mend
moment103319683mo_ment
mummed104411553mumme_d
nimmed11368573nimme_d
nomen75621623no_men_
nonmen8412833nonmen_
normed95014543norme_d
noumena945633noumena
offend13365663_offend
omen66828183_o_men_
omened93711003_o_mened
omens75618963_o_mens
osmund933803_osmund
pommee122813283pomme_e
pommel12277453pomme_l
pommeled1543103pommeled
pommels13235783pommels
portend103411193portend
potmen102713093potmen_
rammed113117303ramme_d
recommends1763163recommends
remend95216553_remend
rimmed114812303rimme_d
roamed95215093roame_d
rodmen939713rodmen_
romped114513653rompe_d
roomed95218543roome_d
scammed14479543scamme_d
scummed14347913scumme_d
socmen1039193socmen_
summand1236263summand
summed114014043summe_d
tombed113812133tombe_d
tomming12359243tomming
torment9316173torment
towmond1394203towmond
womaned1337213womaned
wombed14419233wombe_d
women104619253wo_men_
wommera14144063wommera
wormed124314303worme_d
zoomed183610363zoome_d

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.403443402.0
2DLD Change Limit1340272655.98622390.1
3Display Results2652650.0932849.5
 (SQL Overall)1786912656.48227567.3
 
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.