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

121 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
communer1434930(None) 
commoner142710631commoner
commune13329361commune_
communed15338211communed
communers15338411communers
communes143411241communes
commuter143010151commuter
combiner14259722combiner
commander16127402commander
commencer17147802commencer
commender16167922commender
commenter151410692commenter
commoners15339782commoners
communal1446352communal
communard1644152communard
commute134310442commute_
commuted15288982commuted
commuters15378912commuters
commutes143011892commutes
computer144511512computer
cofounder1543823cofounder
cohune1189423co_hune_
cohunes1249713co_hunes
coiner84323783co__iner
colluder11276873colluder
colourer1037563colourer
columnar1243713columnar
columnea1243673columnea
columned1334923columned
comaker153410603co_maker
combater1439383combater
comber125118503co_m_ber
combine133014723combine_
combined15269183combined
combiners15247943combiners
combines142814623combines
comelier12310653comelier
comember1644163comember
comer95832693co_m__er
comether1537253comether
comfier1439163co_mfier
command14399213comman_d
commanded17136503commanded
commandeer17124113commandeer
commanders17146683commanders
commandery20134253commandery
commando15275753commando
commands15318823commands
commence16149103commence
commenced18157133commenced
commencers18156373commencers
commences17139583commences
commend144010183commen_d
commended17137013commended
commenders17137143commenders
commends15308463commends
comment1310317703commen_t
commented16129613commented
commenters16139483commenters
comments142913883comments
commie124215523comm_ie_
commies133718453comm_ies
commixed2264743commixed
commixes2177353commixes
commode1438123commode_
commodes1539093commodes
common12310803common__
commonest1549253commonest
commonly1744963commonly
commons13311043common_s
commove1635963commove_
commoved1844763commoved
commoves1736963commoves
communards1743403communards
communing16207863communing
communion1546363communion
communise1546803communise
communised1744953communised
communises1646563communises
communism1445633communism
communist1548113communist
community1846213community
communize2446283communize
communized2645283communized
communizes2546253communizes
comparer143611363comparer
compeer133811553co_mpeer
compiler1438373compiler
complier14310253complier
compone136517193compone_
composer145012953composer
compounder1743433compounder
compute134513663compute_
computed154110953computed
computers15339753computers
computes143914553computes
condoner112913413condoner
conducer13127373conducer
confiner13311193confiner
confuter1338513confuter
congener112412203congener
conjurer17117683conjurer
conner84423963co__nner
conquer1838623conqu_er
consumer1238503consumer
convener132913163convener
corner84625623co__rner
coroner94218203co_roner
coruler9311713co_ruler
cosigner1135953cosigner
costumer1275103costumer
counter94220153co__unter
couter84930223co__uter
cowinner1334753cowinner
cozener18328953co_zener
cummer124414593cumm__er
gammoner1345153gammoner
immune1035433_immune_
immunes1136083_immunes
summoner1245533summoner
uncommoner1653123uncommoner

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.420425454.8
2DLD Change Limit1461621216.50322476.1
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.96925640.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.