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

123 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
commoners1533978(None) 
commoner142710631commoner_
communers15338411communers
combiners15247942combiners
commanders17146682commanders
commencers18156372commencers
commenders17137142commenders
commenters16139482commenters
commodes1539092commode_s
commonest1549252commonest
commonness1644362commonness
commons13311042common__s
commoves1736962commove_s
communer14349302communer_
communes143411242commune_s
commuters15378912commuters
composers153910632composers
condoners122811512condoners
coroners104016222co_roners
gammoners1444562gammoners
summoners1344732summoners
almoners1068133_almoners
clamorers1345783clamorers
cloners94514823c__loners
coiners93620753co__iners
cojones163512103co_jone_s
colonels104210463co_lonels
colones96124433co_lone_s
colorers10312183co_lorers
comakers16339173co_makers
combaters1538113combaters
combers134516623co_m_bers
combineds16255283combineds
combiner14259723combiner_
combines142814623combine_s
comedones1446933comedone_s
comembers1744223comembers
comers105328083co_m__ers
comethers1637443comethers
comfiness1646953comfiness
comforters17275193comforters
commandeers18123183commandeers
commander16127403commander_
commandery20134253commandery
commandos16245963commandos
commands15318823comman_ds
commencer17147803commencer_
commences17139583commences
commender16167923commender_
commends15308463commen_ds
commenter151410693commenter_
comments142913883commen_ts
commies133718453comm_ie_s
commixes2177353commixe_s
commode1438123commode__
commodore1644203commodore
commodores1743973commodores
common12310803common___
commonage1645733commonage
commonages1745913commonages
commonly1744963common_ly
commonsense1752523commonsense
commonweal1982633commonweal
commonweals20112293commonweals
commove1635963commove__
commoved1844763commove_d
communard1644153communard
communards1743403communards
commune13329363commune__
communed15338213commune_d
commuter143010153commuter_
commutes143011893commute_s
comonomers1644523comonomers
comparers15319393comparers
compeers143410013co_mpeers
compilers1537053compilers
compliers1538293compliers
compone136517193compone__
component15411083component
components1646943components
composer145012953composer_
composes145017123compose_s
composters16388323composters
compotes144716513compote_s
compounders1843143compounders
computers15339753computers
condolers122710573condolers
condoner112913413condoner_
condones112817393condone_s
confiners1439953confiners
congeners122511133congeners
conjoiners1955403conjoiners
conners94023113co__nners
consolers112510923consolers
conveners142911443conveners
convokers18246103convokers
cooers84324563co__o_ers
cookers134619463co__okers
coolers93522493co__olers
coopers114019483co__opers
cooters94525723co__oters
corners94723313co__rners
coronels104012153co_ronels
coroner94218203co_roner_
coronets103814363co_ronets
cosigners1245133cosigners
cosmoses1239713cosmose_s
cowinners1444133cowinners
cozeners19297783co_zeners
crayoners1444503crayoners
crooners103911393c_rooners
cummers133713483cumm__ers
gammoner1345153gammoner_
homeowners1843373homeowners
hommoses1538163hommose_s
hormones13311173hormone_s
mooners94015343__mooners
motioners1146573motioners
poisoners1146113poisoners
someones1039063someone_s
sooners73916643so__oners
summoner1245533summoner_
uncommoner1653123uncommoner_

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411236.81321817.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.26524596.1
 
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.