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

155 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
unclogs103680(None) 
unclog956601unclog_
analogs82810452analogs
beclogs1237072beclogs
clogs85519552__clogs
incogs937902inc_ogs
uncles8317162uncl_es
unclips1136432unclips
uncloak1365472uncloak
uncloaks1444132uncloaks
unclose91111642unclose
uncloses10910942uncloses
uncloud1046432uncloud
unclouds1144882unclouds
uncos74117032unc_o_s
uncross938192uncross
unplugs1042982unplugs
analog7159973analog_
analogy11177853analogy
anchors123912953anchors
anchos114214893ancho_s
anglos74413913anglo_s
antilogs949603antilogs
apologs1038593apologs
backlogs1746633backlogs
beclog1136863beclog_
blogs85319233__blogs
buncos104011593bunc_o_s
clags85621123__clags
clods85320863__clods
clog76123243__clog_
clons75228133__clons
clops95924853__clops
clots75627643__clots
cloys104916943__cloys
cogs77340033__c_ogs
cologs96517353_cologs
cyclops1635383cyclops
cyclos1338073cyclo_s
decalogs1245633decalogs
dialogs938103dialogs
duologs935363duologs
enclose999993enclose
encloses10911053encloses
enology11239813enology
epilogs1076583epilogs
flogs95919963__flogs
functors1335743functors
gundogs1034603gun_dogs
inclips1135963inclips
inclose9910223inclose
incloses101610533incloses
incog838253inc_og_
incross937663incross
inflows1335523inflows
isologs837433isologs
juncoes16338073junc_oes
juncos15449233junc_o_s
logs57343113___logs
monologs112210533monologs
nogs56534613_n__ogs
nolos54423353_nolo_s
nucleons1065483nucleons
nucleus956573nucleus
nuncios937113nuncio_s
nuncles939843nuncl_es
nylons9267973_nylons
oncology14216973oncology
prologs103512133prologs
putlogs1065083putlogs
sawlogs1135393sawlogs
slogs64521843__slogs
snogs66017493sn__ogs
sundogs947103sun_dogs
sunglows1244083sunglows
ufology14244563ufology
unblock1545793unblock
unblocks1644523unblocks
unbolts9247803unbolts
uncage93014873unc_age
uncages103213773uncages
uncakes133012743uncakes
uncaps1039813unc_aps
uncases93516553uncases
unchoke16248193unchoke
unchokes17227273unchokes
uncials92510523uncials
uncinus937403uncinus
unclad938913uncl_ad
unclamp1344993unclamp
unclamps1443693unclamps
unclasp1135963unclasp
unclasps1244573unclasps
unclassy1343653unclassy
uncle7317053uncl__e
unclean946973unclean
unclear936573unclear
uncleft1257493uncleft
unclip1046993uncl_ip
unclogged1443933unclogged
unclosed111010503unclosed
unclothe1345703unclothe
unclothes1445143unclothes
uncloudy1443013uncloudy
uncloyed1487343uncloyed
unco66021403unc_o__
uncock1438563unc_ock
uncocks1537233uncocks
uncoil8811853unc_oil
uncoils979533uncoils
uncool8610113unc_ool
uncork1239043unc_ork
uncorks1337443uncorks
uncoy104111413unc_o_y
uncrown1236323uncrown
uncrowns1344363uncrowns
unctions1039733unctions
unctuous1044853unctuous
uncuffs1543143uncuffs
uncurbs1134913uncurbs
uncurls937123uncurls
uncus74014983unc__us
undoes73917403un_does
unfolds11146803unfolds
unglove1136103unglove
ungloves1245293ungloves
unglues836993unglues
unhangs1136203unhangs
unhoods1137503unhoods
unhooks1436413unhooks
unions64216753un_ions
unipods1095703unipods
unisons748423unisons
unknots1144303unknots
unlays93810493un_lays
unless62413073un_less
unload73010803un_load
unloads8278523un_loads
unlock1248533un_lock
unlocks1337063un_locks
unloose797863un_loose
unmolds10135743unmolds
unmoors945903unmoors
unpegs9256233un_pegs
unplug954413unplug_
unrigs7159003un_rigs
unrolls797793unrolls
unroofs1035783unroofs
unroots738563unroots
unslings937283unslings
unsnags835463unsnags
unstops936993unstops
upflows1543513upflows
urology11217583urology
weblogs1334223weblogs

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.1431249587.4
2DLD Change Limit1340271556.51620568.9
3Display Results1551550.0602583.3
 (SQL Overall)1786911556.71926594.9
 
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.