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

290 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
uproot831412(None) 
unroot6315551unroot
uproots937141uproots
enroot6615992enroot
outroot7516562outroot
proof105221532_proof
prost75434102_prost
root45655922__root
sprout8419402sprout
taproot9412672taproot
unroof9410192unroof
unroots738562unroots
upfront1246972upfront
upmost1068192upmost
uproar8106932uproar
uprootal1043452uprootal
uprooted1186392uprooted
uprooter1085242uprooter
uprose82311482uprose
upshoot1256692upshoot
upshot1138452upshot
adroit7518793adroit
afoot8420113_afoot
agorot7415003agorot
alumroot1044893alumroot
aport75432173ap_ort
apricot111010183apricot
apron7318833apr_on
aprons8316993aprons
apropos1138843apropos
argot67728653_argot
bhoot104322103_bhoot
boot67759373__boot
broo65129823_broo_
brood84620243_brood
brook114717763_brook
broom95022213_broom
broos75126413_broos
burbot10815653burbot
cahoot11416473cahoot
carrot8423123carrot
cheroot12413693cheroot
cloot76127053_cloot
clubroot1244843clubroot
coot67860383__coot
croft105622683_croft
crook115217573_crook
croon75522783_croon
cuprous1149743cuprous
disroot8413563disroot
droit65127123_droit
drool65416103_drool
droop85814823_droop
dropt86924433_dropt
enroots738713enroots
ergot65422893_ergot
foot76248013__foot
forgot104318133forgot
front85029223_front
frost84727833_frost
galoot72719163galoot
griot65328413_griot
groat65531973_groat
groom85317983_groom
grot55942053_gr_ot
grout65330423_grout
gumboot1246493gumboot
gunroom1045053gunroom
harlot94422803harlot
heriot9422343heriot
hoot75752103__hoot
karoo92519583karoo_
karoos102415803karoos
kroon94514483_kroon
lirot5430033lir_ot
loot46955823__loot
marmot10318743marmot
maroon83118203maroon
merlot83217603merlot
moot67653623__moot
mudroom1244953mudroom
muskroot1444353muskroot
oot311274693___oot
outfoot10411493outfoot
outroots839873outroots
parrot8320663parrot
phot95534363_p_hot
photo104417233_photo
picot95031013_picot
pilot77435063_pilot
pinot78737293_pinot
pivot106523873_pivot
plot66141233_p_lot
poet65552903_p_oet
poo57757113_p_oo_
pood75934323_p_ood
poof95541663_p_oof
pooh96027383_p_ooh
pool65835953_p_ool
poon67341263_p_oon
poop86532813_p_oop
poor65630223_p_oor
poos65949113_p_oos
port66059633_p_ort
post67953363_p_ost
pot58078433_p__ot
pout65752553_p_out
prao66229023_prao_
praos74923563_praos
prat65952043_pr_at
preop94715873_preop
prest75736353_prest
print74837463_print
prion75119993_prion
prior74316173_prior
pro55837263_pr_o_
proa66229963_pr_oa
proas75028803_proas
probe94320813_probe
probit103218353_probit
prod76129503_pr_od
prods85523553_prods
proem94818273_proem
prof96134663_pr_of
profit113016273_profit
profs105120893_profs
prog75729003_pr_og
progs86624153_progs
projet15315183_projet
prole74527793_prole
prolog94212973_prolog
prom87631703_pr_om
promo95620003_promo
promos105116423_promos
promote11313143_promote
prompt12313013_prompt
proms95426413_proms
prone75332623_prone
prong85218113_prong
pronota939763_pronota
pronto8313993_pronto
proofs114511683_proofs
prop85932813_pr_op
props95726883_props
pros65742783_pr_os
prose75835123_prose
prosit85124593_prosit
proso77222413_proso
prosos85718553_prosos
pross76529403_pross
prosy106319253_prosy
proton84318893_proton
proud84615483_proud
prove104823193_prove
provost1238573_provost
prow97030383_pr_ow
prowl105615123_prowl
prows106327013_prows
proxy175011013_proxy
prutot8311823_prutot
purest84021933purest
purist85525053purist
purport1159393purport
putout8315113putout
reboot84119333reboot
redroot8312903redroot
reproof1238783reproof
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
ryot75528563__ryot
scoot75729153_scoot
scroop10299783scroop
sheroot10414373sheroot
shoot84235913_shoot
snoot55030143_snoot
soot45761063__soot
spigot9312603spigot
spoof105019013sp_oof
spook115416043sp_ook
spool75219043sp_ool
spoon74719443sp_oon
spoor75016353sp_oor
sport75935983sp_ort
spot65540693sp__ot
spout75029633sp_out
sprat76635973spr_at
sprent84522383sprent
sprint84526793sprint
sprit76736403spr_it
sprouts949983sprouts
strook10410303strook
sunproof1344603sunproof
sunroof1047053sunroof
sunroom947013sunroom
superhot13410223superhot
support11310523support
taproom1147963taproom
taproots1047253taproots
tarot55943933tar_ot
throat94819753throat
toot45958883__toot
torot56139943tor_ot
troop76417533_troop
trooz145016153_trooz
trot46351313_tr_ot
trout57332573_trout
turbot8914263turbot
unbolt83013893unbolt
uncool8610113uncool
ungot61718063u_ngot
unhood1039233unhood
unhook1347523unhook
unknot1037413unknot
unmoor836313unmoor
unrent63219783unrent
unrest62918853unrest
unrobe82611673unrobe
unroll61210073unroll
unroofs1035783unroofs
unrooted9810513unrooted
unrove92511683unrove
upbeat10911513upbeat
upboil1096453upboil
upbore10247883upbore
upbow1245613up_bow
upbows1384683upbows
upcast102710093upcast
upcoast1165543upcoast
upcoil10126193upcoil
upcourt1146103upcourt
updart9310743updart
updo76712883up_do_
updos8389513up_dos
updove1234483updove
updraft1346033updraft
upflow1433523upflow
upfold12124953upfold
upgirt9117263upgirt
upgrow1234273upgrow
upgrown1343853upgrown
upgrows1334323upgrows
upgrowth1741953upgrowth
uphold12126903uphold
uphove1436133uphove
uphroe1136083uphroe
uphroes1236303uphroes
uplift114610653uplift
uplit76020803up_lit
upload9257783upload
upo58925863up__o_
upon65817583up__on
upprop944093upprop
upprops1044223upprops
uprate83916543uprate
uprear8168793uprear
upright13178293upright
uprise82313693uprise
uproars986453uproars
uprootals1142643uprootals
uprooters1164253uprooters
uprooting1276903uprooting
uprouse937223uprouse
uprush1135783uprush
upsent83314063upsent
upset73222593up_set
upshoots1344233upshoots
upshots1235193upshots
upsoar8105683upsoar
upstood1044243upstood
uptilt8410803uptilt
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
upwaft1444943upwaft
uropod937263u_ropod
utmost878483utmost
varoom11411413varoom
vroom105312473_vroom

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.376475242.0
2DLD Change Limit1127162905.78319490.9
3Display Results2902900.0933118.3
 (SQL Overall)1786912906.25228581.4
 
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.