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

150 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
commoner14271063(None) 
commoners15339781commoners
communer14349291communer
combiner14259722combiner
commander16127402commander
commencer17147802commencer
commender16167922commender
commenter151410682commenter
commode1438122commode_
commodes1539092commodes
common12310802common__
commonest1549252commonest
commonly1744962commonly
commons13311042common_s
commove1635962commove_
commoved1844762commoved
commoves1736962commoves
commune13329352commune_
communed15338202communed
communers15338402communers
communes143411232communes
commuter143010132commuter
compone136517192compone_
composer145012952composer
condoner112913392condoner
coroner94218202co_roner
gammoner1345152gammoner
summoner1245532summoner
uncommoner1653112uncommoner
almoner949383_almoner
clamorer1236903clamorer
cloner84418093c__loner
cocooned1337293cocooned
coiner84323783co__iner
cojones163512103co_jones
colone85425003co_lone_
colonel94213283co_lonel
colones96124433co_lones
colorer9312523co_lorer
comaker153410603co_maker
combater1439373combater
comber125118503co_m_ber
combine133014713combine_
combined15269183combined
combiners15247943combiners
combines142814623combines
comedones1446933comedones
comelier12310653comelier
comember1644163comember
comer95832693co_m__er
comether1537253comether
comfier1439163co_mfier
comforter16255983comforter
command14399213comman_d
commanded17136503commanded
commandeer17124113commandeer
commanders17146683commanders
commandery20134253commandery
commando15275753commando
commands15318813commands
commence16149103commence
commenced18157133commenced
commencers18156373commencers
commences17139573commences
commend144010183commen_d
commended17137013commended
commenders17137143commenders
commends15308463commends
comment1310317703commen_t
commented16129603commented
commenters16139473commenters
comments142913873comments
commie124215523comm_ie_
commies133718443comm_ies
commixed2264743commixed
commixes2177343commixes
commodore1644203commodore
commonage1645733commonage
commonages1745903commonages
commonness1644363commonness
commonweal1982633commonweal
communal1446353communal
communard1644153communard
commute134310423commute_
commuted15288963commuted
commuters15378883commuters
commutes143011873commutes
comonomer1545023comonomer
comose105016843co_mose_
comparer143611363comparer
compeer133811553co_mpeer
compiler1438373compiler
complier14310253complier
component15411083component
compony1613011913compon_y
compose135716663compose_
composed154612063composed
composers153910613composers
composes145017113composes
composter15369563composter
compote135616463compote_
compotes144716513compotes
compounder1743433compounder
computer144511503computer
condoler113412113condoler
condone102616293condone_
condoned122612023condoned
condoners122811493condoners
condones112817393condones
confiner13311193confiner
congener112412193congener
conjoiner1855933conjoiner
conner84423963co__nner
consoler102812613consoler
convener132913163convener
convoker17226903convoker
cooer74831013co__o_er
cooker124722453co__oker
cooler84824713co__oler
cooper104221123co__oper
cooter85128613co__oter
cordoned12229613cordoned
corner84625623co__rner
coronel94515223co_ronel
coroners104016223co_roners
coronet94227173co_ronet
cosigner1135953cosigner
cosmoses1239703cosmoses
cottoned1138033cottoned
cowinner1334753cowinner
cozener18328953co_zener
crayoner1344853crayoner
crooner93714043c_rooner
cummer124414593cumm__er
doggoner1143863doggoner
gammoned1444993gammoned
gammoners1444563gammoners
homeowner1743483homeowner
hommoses1538153hommoses
hormone12410503hormone_
hormones13311163hormones
mooner85317833__mooner
motioner1037593motioner
nonmoney1346263nonmoney
poisoner1046983poisoner
someone938813someone_
someones1039063someones
sooner64220463so__oner
summoned1345723summoned
summoners1344733summoners

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.1701051123.5
2DLD Change Limit1461621507.31319986.6
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.