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

281 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
unroot631555(None) 
enroot6615991enroot
unroof9410191unroof
unroots738561unroots
uproot8314121uproot
enroots738712enroots
gunroom1045052gunroom
outroot7516562outroot
root45655922__root
snoot55030142sn_oot
sunroof1047052sunroof
sunroom947012sunroom
unbolt83013892unbolt
uncool8610112uncool
ungot61718062un_got
unhood1039232unhood
unhook1347522unhook
unknot1037412unknot
unmoor836312unmoor
unrent63219782unrent
unrest62918852unrest
unrobe82611672unrobe
unroll61210072unroll
unroofs1035782unroofs
unrooted9810512unrooted
unrove92511682unrove
uproots937142uproots
adroit7518793adroit
afoot8420113_afoot
agorot7415003agorot
alumroot1044893alumroot
argot67728653_argot
bhoot104322103_bhoot
boot67759373__boot
broo65129823_broo_
brood84620243_brood
brook114717763_brook
broom95022213_broom
broos75126413_broos
burbot10815653burbot
burnout9310453burnout
cahoot11416473cahoot
carrot8423123carrot
cheroot12413693cheroot
cloot76127053_cloot
clubroot1244843clubroot
coot67860383__coot
croft105622683_croft
crook115217573_crook
croon75522783_croon
disroot8413563disroot
droit65127123_droit
drool65416103_drool
droop85814823_droop
dropt86924433_dropt
enrapt8313013enrapt
enrobe86610793enrobe
enrol51014283enr_ol
enroll61110073enroll
enrols61213383enrols
enrooted977423enrooted
ergot65422893_ergot
finfoot1347173finfoot
foot76248013__foot
forgot104318133forgot
front85029223_front
frost84727833_frost
galoot72719163galoot
griot65328413_griot
groat65531973_groat
groom85317983_groom
grot55942053_gr_ot
grout65330423_grout
gumboot1246493gumboot
gunboat1047363gunboat
gunrooms1144323gunrooms
gunshot1156643gunshot
harlot94422803harlot
heriot9422343heriot
hoot75752103__hoot
indoor738403indoor
ingot61221063in_got
inkpot1237813inkpot
inmost8411363inmost
inro45920793inr_o_
inroad737933inroad
intort6418923intort
introit7414533introit
karoo92519583karoo_
karoos102415803karoos
knot85630503kn__ot
knout95018263kn_out
kroon94514483_kroon
lirot5430033lir_ot
loot46955823__loot
marmot10318743marmot
maroon83118203maroon
merlot83217603merlot
moot67653623__moot
mudroom1244953mudroom
muskroot1444353muskroot
noo37154043_n_oo_
nook85728493_n_ook
noon47134623_n_oon
not39474663_n__ot
nowt78833753_n_owt
oot311274693___oot
outfoot10411493outfoot
outroots839873outroots
parrot8320663parrot
pinkroot1445863pinkroot
proof105221533_proof
prost75434103_prost
reboot84119333reboot
redroot8312903redroot
reroof9315003reroof
riot45947213__riot
robot7325973__robot
rood56733003__rood
roof75738833__roof
rook85532033__rook
room66235083__room
roost55730933__roost
roots55933673__roots
rooty86423023__rooty
rot37282953__r_ot
roto45935053__roto
rout46153283__rout
runout6414873run_out
ryot75528563__ryot
scoot75729153_scoot
scroop10299783scroop
sheroot10414373sheroot
shoot84235913_shoot
snood64616163sn_ood
snook95115573sn_ook
snool55118643sn_ool
snoop75317173sn_oop
snoots64216683sn_oots
snooty94211513sn_ooty
snort54833753sn_ort
snot44745453sn__ot
snout54530633sn_out
soot45761063__soot
sprout8419403sprout
strook10410303strook
sunproof1344603sunproof
sunroofs1144763sunroofs
sunrooms1045723sunrooms
sunspot947163sunspot
taproot9412673taproot
tarot55943933tar_ot
throat94819753throat
toot45958883__toot
torot56139943tor_ot
troop76417533_troop
trooz145016153_trooz
trot46351313_tr_ot
trout57332573_trout
turbot8914263turbot
turnout7410283turnout
unapt710421593un_apt
unbelt83015693unbelt
unbent83216593unbent
unbolts9247803unbolts
unbooted1188773unbooted
unborn83310813unborn
unbosom1144483unbosom
unbox1438753un_box
unbroke13217743unbroke
uncast84215713uncast
unclog956603unclog
unco66021403un_co_
uncock1438563uncock
uncoil8811853uncoil
uncork1239043uncork
uncos74117033un_cos
uncouth1247173uncouth
uncoy104111413un_coy
uncross938193uncross
uncrown1236323uncrown
uncut73219173un_cut
underfoot1347033underfoot
undo55620153un_do_
undock1337703undock
undoer73113043undoer
undoes73917403undoes
undone7914253undone
undrest8313013undrest
unfelt92413463unfelt
unfit84518563un_fit
unfixt16398423unfixt
unfold10179703unfold
unfond10149113unfond
unforgot1243593unforgot
unfrock1674633unfrock
unfroze1945413unfroze
ungirt71112713ungirt
unhat81119263un_hat
unholy1238163unholy
unhoods1137503unhoods
unhooks1436413unhooks
unhurt9311253unhurt
union54519793un_ion
unions64216753unions
unipod946853unipod
unison649033unison
unit45140073un__it
unjoint1449233unjoint
unjust1337873unjust
unkent103116053unkent
unkept123710873unkept
unknit1068593unknit
unknots1144303unknots
unlet54133333un_let
unlit55025463un_lit
unload73010803unload
unlock1248533unlock
unloose797863unloose
unmeet83815743unmeet
unmet74426393un_met
unmixt15378703unmixt
unmold9148313unmold
unmoors945903unmoors
unmown11296093unmown
unpent83117373unpent
unquote1645903unquote
unread73412673unread
unreal64414453unreal
unreel63612933unreel
unrests7229463unrests
unrig61711413unr_ig
unrigs7159003unrigs
unrip72012863unr_ip
unripe82012093unripe
unrips8199453unrips
unrobed102711213unrobed
unrobes9269733unrobes
unrolls797793unrolls
unroofed12106773unroofed
unrooting1098833unrooting
unroped102812103unroped
unrough11105233unrough
unround8138503unround
unroven10238143unroven
unruly938083unruly
unseat64221023unseat
unsent63820963unsent
unset54532433un_set
unshod1067603unshod
unshut939013unshut
unsold71410513unsold
unsown9328433unsown
unspool945163unspool
unstop837473unstop
unto45824283un_to_
untold7149683untold
untorn63012343untorn
untrod769853untrod
unvext1658173unvext
unwept11389813unwept
unwet84423173un_wet
unwit84417523un_wit
unwon84512343un_won
unwooed11229773unwooed
unworn93411333unworn
unwove12238883unwove
unyoke1367293unyoke
upfront1246973upfront
upmost1068193upmost
uproar8106933uproar
uprootal1043453uprootal
uprooted1186393uprooted
uprooter1085243uprooter
uprose82311483uprose
upshoot1256693upshoot
upshot1138453upshot
uropod937263u_ropod
utmost878483utmost
varoom11411413varoom
vroom105312473_vroom

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.420425454.8
2DLD Change Limit1127162814.89023050.3
3Display Results2812810.1431965.0
 (SQL Overall)1786912815.45332769.3
 
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.