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

239 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
enroot661599(None) 
enroots738711enroots
unroot6315551unroot
enrapt8313012enrapt
enrobe86610792enrobe
enrol51014282enr_ol
enroll61110072enroll
enrols61213382enrols
enrooted977422enrooted
ergot65422892e_rgot
redroot8312902redroot
root45655922__root
snoot55030142sn_oot
unroof9410192unroof
unroots738562unroots
uproot8314122uproot
adroit7518793adroit
afoot8420113_afoot
agorot7415003agorot
argot67728653_argot
bedroom1247083bedroom
beetroot1047253beetroot
bhoot104322103_bhoot
boot67759373__boot
broo65129823_broo_
brood84620243_brood
brook114717763_brook
broom95022213_broom
broos75126413_broos
burbot10815653burbot
cahoot11416473cahoot
carrot8423123carrot
cheroot12413693cheroot
cloot76127053_cloot
coot67860383__coot
croft105622683_croft
crook115217573_crook
croon75522783_croon
defrost1139553defrost
disroot8413563disroot
droit65127123_droit
drool65416103_drool
droop85814823_droop
dropt86924433_dropt
earshot10410823earshot
ebook114510803e_book
effort1238623effort
egret63327313egr_et
enact73525363en_act
enamor838753enamor
encode9310443encode
encore8314773encore
encrust947873encrust
encrypt1445323encrypt
encyst1136203encyst
endmost1056763endmost
endnote855743endnote
endopod1145763endopod
endow94510983en_dow
endows104610423endows
enfold10137613enfold
engirt71112613engirt
englut738453englut
engraft11118613engraft
engross837123engross
enjoin1357833enjoin
enjoy1545963en_joy
enjoys1644603enjoys
enlist6417043enlist
enoki9268873en_oki
enol45823823en__ol
enols54718403en_ols
enorm74415633en_orm
enow77819873en__ow
enows85115493en_ows
enrage72715073enrage
enrich1138943enrich
enrobed10279253enrobed
enrober9218623enrober
enrobes92211113enrobes
enrolls7108093enrolls
enrooting10128133enrooting
ensoul638253ensoul
entoil6912493entoil
entomb1037363entomb
entozoa1644233entozoa
entrant7318873entrant
entreat7315263entreat
entrepot1046193entrepot
entropy1247353entropy
entrust7410883entrust
envoi878023en_voi
envois988703envois
envoy1156723en_voy
envoys1255143envoys
enwomb1344973enwomb
enzootic1944323enzootic
erect74129333e_rect
ergo56420153e_rgo_
ergots74512373e_rgots
erode64520993e_rode
eros45238453e_r_os
erose55727273e_rose
errant6618733errant
error53712233e_rror
errors63311313errors
erst47436433e_r_st
eruct74022353e_ruct
erupt74220063e_rupt
escort84616483escort
escot75320083e_scot
euro45325273eur_o_
euroky1334823euroky
euros54920243eur_os
exhort16410803exhort
export15412183export
extort13513973extort
finfoot1347173finfoot
foot76248013__foot
forgot104318133forgot
front85029223_front
frost84727833_frost
galoot72719163galoot
genro64914033genr_o_
genros74211333genr_os
gentoo7311313gentoo_
gentoos838633gentoos
griot65328413_griot
groat65531973_groat
groom85317983_groom
grot55942053_gr_ot
grout65330423_grout
gunroom1045053gunroom
harlot94422803harlot
hencoop1443813hencoop
heriot9422343heriot
hoot75752103__hoot
indoor738403indoor
ingot61221063in_got
inkpot1237813inkpot
inmost8411363inmost
inro45920793inr_o_
inroad737933inroad
intort6418923intort
introit7414533introit
karoo92519583karoo_
karoos102415803karoos
knot85630503kn__ot
knout95018263kn_out
kroon94514483_kroon
legroom1076093legroom
lirot5430033lir_ot
loot46955823__loot
marmot10318743marmot
maroon83118203maroon
merlot83217603merlot
moot67653623__moot
nerol51017813ner_ol
neroli61111153neroli
nerols6914883nerols
noo37154043_n_oo_
nook85728493_n_ook
noon47134623_n_oon
not39474663_n__ot
nowt78833753_n_owt
oot311274693___oot
outroot7516563outroot
parrot8320663parrot
pinkroot1445863pinkroot
proof105221533_proof
prost75434103_prost
reboot84119333reboot
redroots937753redroots
refront10313263refront
regroom1077293regroom
reproof1238783reproof
reroof9315003reroof
reshoot102513893reshoot
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
ryot75528563__ryot
scoot75729153_scoot
scroop10299773scroop
seaboot9512333seaboot
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
sunroof1047053sunroof
sunroom947013sunroom
taproot9412673taproot
tarot55943933tar_ot
tearoom939063tearoom
throat94819753throat
toot45958883__toot
torot56139943tor_ot
troop76417533_troop
trooz145016153_trooz
trot46351313_tr_ot
trout57332573_trout
turbot8914263turbot
unbolt83013893unbolt
uncool8610113uncool
ungot61718063un_got
unhood1039233unhood
unhook1347523unhook
unknot1037413unknot
unmoor836313unmoor
unrent63219783unrent
unrest62918853unrest
unrobe82611673unrobe
unroll61210073unroll
unroofs1035783unroofs
unrooted9810513unrooted
unrove92511683unrove
uproots937143uproots
varoom11411413varoom
vroom105312473_vroom
webfoot1544213webfoot

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162396.17318259.5
3Display Results2392390.0633793.7
 (SQL Overall)1786912396.37628025.6
 
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.