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

133 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
commends1530846(None) 
commands15318821commands
commend144010181commend_
comments142913881comments
compends15378251compends
command14399212command_
commando15275752commando
commandos16245962commandos
commence16149102commence
commences17139582commences
commendam1544952commendam
commendams1644312commendams
commended17137012commended
commender16167922commender
commenders17137142commenders
comment1310317702commen_t
commons13311042common_s
communes143411242communes
compend144010302compend_
contends112810572contends
recommends1763162recommends
amends94713283__amends
bookends15374853bookends
calends1039523c_alends
cements112714223c_ements
coagents1138453coagents
coamings13349293coamings
coattends1243913coattends
codens94821013co_den_s
coeds85920163co__e_ds
coextends1942323coextends
cofounds1444713cofounds
coheads13289233co_heads
coleads102911423co_leads
combed135516543combe_d_
combers134516623combe_rs
combes125321733combe__s
combineds16255283combineds
combines142814623combines
combings15348323combings
comedo11359603co_me_do
comedos12329073co_medos
comedy14378233co_me_dy
comers105328083co_me_rs
comes97246993co_me__s
comets105823583co_me_ts
comings124013533co_mings
commanded17136503commanded
commander16127403commander
commanders17146683commanders
commandoes17255263commandoes
commas124814573comm__as
commenced18157133commenced
commencer17147803commencer
commencers18156373commencers
commending1846633commending
commensal1546023commensal
commensals1645673commensals
commented16129613commented
commenter151410693commenter
commenters16139483commenters
commerce16116323commerce
commerces17147233commerces
commies133718453comm_ies
commits133812383comm_its
commixes2177353commixes
commode1438123comm_ode
commodes1539093commodes
common12310803common__
commoner142710633commoner
commoners15339783commoners
commonest1549253commonest
commonly1744963commonly
commoves1736963commoves
communal1446353communal
communards1743403communards
commune13329363commun_e
communed15338213communed
communer14349303communer
communers15338413communers
communise1546803communise
communism1445633communism
communist1548113communist
commutes143011893commutes
comped135919873compe_d_
compeers143410013compeers
compels133210893compe_ls
compendia1643953compendia
comperes143217973comperes
competes144117243competes
compounds1654503compounds
comtes106222813comte__s
concents122516603concents
consents102715893consents
contend103511893contend_
contents104018213contents
convenes132916913convenes
convents132614603convents
copens106119963co_pen_s
cormels113813373corme_ls
cosmids1237633cosm_ids
covens114919263co_ven_s
cowbinds1634453cowbinds
cowhands1765263cowhands
cowherds1735423cowherds
cowmen13810923cowmen__
cozens176314923co_zen_s
cummers133713483cumme_rs
cummins1358963cummin_s
cymenes1477413c_ymenes
discommends1962773discommends
dolmens10388693dolmen_s
emends95711433__emends
foments122912053fo_ments
forfends1544833forfends
godsends11113353godsends
gormands1266563gormands
impends12376803_impends
loments93413473lo_ments
mends84927693___mends
moments113113123mo_ments
offends14234293_offends
omens75618963_o_men_s
osmunds1042883_osmunds
pommels13235793pomme_ls
portends11358963portends
recommend1664323recommend_
remends105013033_remends
summands1344713summands
tommed113310143tomme_d_
torments10310453torments
towmonds1493493towmonds
wommeras15133783wommeras

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 Limit1461621337.12320519.7
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.60923484.2
 
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.