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

169 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
unclog95660(None) 
unclogs1036801unclogs
analog7159972analog
beclog1136862beclog
clog76123242__clog
incog838252inc_og
unclad938912unclad
uncle7317052uncl_e
uncles8317162uncles
unclip1046992unclip
uncloak1365472uncloak
unclose91111642unclose
uncloud1046432uncloud
unco66021402unc_o_
uncool8610112uncool
uncos74117032unc_os
uncoy104111412unc_oy
unplug954412unplug
analogs82810453analogs
analogy11177853analogy
ancho104515303ancho_
anchor113911973anchor
anchos114214893anchos
ancon75718233anc_on
anglo65215373anglo_
anglos74413913anglos
antilog838623antilog
apolog938903apolog
backlog1635773backlog
beclogs1237073beclogs
blog75723823__blog
bunco94616083bunc_o_
buncos104011593bunc_os
clag75924573__clag
clod76124613__clod
clogs85519553__clogs
clon66232483__clon
clop86929893__clop
clot66542423__clot
cloy96623833__cloy
cog69552903__c_og
colog86619933_colog
cyclo1237703cyclo_
cyclos1338073cyclos
decalog1136003decalog
dialog837973dialog
duolog835803duolog
enclose999993enclose
endlong934823endlong
enology11239813enology
epilog976463epilog
flog85523893__flog
functor1235203functor
gundog935793gun_dog
inclip1036823inclip
inclose9910223inclose
incogs937903inc_ogs
inflow1235293inflow
isolog737403isolog
junco144612203junc_o_
juncos15449233junc_os
log46252683___log
monolog10259353monolog
nog46847313_n__og
nolo46229313_nolo_
nolos54423353_nolos
nuclei857723nuclei
nucleon945553nucleon
nuncio837973nuncio_
nuncios937113nuncios
nuncle839363nuncl_e
nuncles939843nuncles
nylon82910513_nylon
oncology14216973oncology
prolog94212973prolog
putlog965553putlog
sawlog1035793sawlog
slog56728273__slog
snog55623633sn__og
sundog837613sun_dog
sunglow1143943sunglow
ufology14244563ufology
unblock1545793unblock
unbolt83013893unbolt
unbox1438753un_box
uncage93014873uncage
uncake122813523uncake
uncap9312283unc_ap
uncaps1039813uncaps
uncase83817433uncase
uncast84215713uncast
unchic1338643unchic
unchoke16248193unchoke
unci65019463unc__i
uncia75015163unc_ia
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
unclamp1344993unclamp
unclasp1135963unclasp
unclean946973unclean
unclear936573unclear
uncleft1257493uncleft
unclips1136433unclips
uncloaks1444133uncloaks
unclogged1443933unclogged
unclosed111010503unclosed
uncloses10910943uncloses
unclosing1247753unclosing
unclothe1345703unclothe
unclouds1144883unclouds
uncloudy1443013uncloudy
uncloyed1487343uncloyed
uncloying1555813uncloying
uncock1438563uncock
uncoil8811853uncoil
uncork1239043uncork
uncross938193uncross
uncrown1236323uncrown
unction9310663unction
uncuff1436113uncuff
uncurb1037043uncurb
uncurl839413uncurl
uncus74014983unc_us
uncut73219173unc_ut
uncute82912133uncute
undo55620153un_do_
unfold10179703unfold
unglove1136103unglove
unglue748003unglue
ungot61718063un_got
unhang1038443unhang
unholy1238163unholy
unhood1039233unhood
unhook1347523unhook
unhung1035283unhung
unicolor1043493unicolor
union54519793un_ion
unipod946853unipod
unison649033unison
unknot1037413unknot
unlay84613703un_lay
unled64021073un_led
unlet54133333un_let
unlit55025463un_lit
unload73010803un_load
unlock1248533un_lock
unmold9148313unmold
unmoor836313unmoor
unpeg8309363un_peg
unplugs1042983unplugs
unrig61711413un_rig
unroll61210073unroll
unroof9410193unroof
unroot6315553unroot
unshod1067603unshod
unsling8313643unsling
unslung844563unslung
unsnag736393unsnag
unsold71410513unsold
unstop837473unstop
unsung736983unsung
unto45824283un_to_
untold7149683untold
untrod769853untrod
unwon84512343un_won
upflow1433523upflow
urology11217583urology
weblog1234223weblog

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161695.53320371.6
3Display Results1691690.0632682.5
 (SQL Overall)1786911695.96929936.5
 
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.