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

257 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
rootlet7301573(None) 
rootle63214451rootle_
rootled83410531rootled
rootles73215631rootles
rootlets8308651rootlets
booklet132312642booklet
boomlet112412272boomlet
bootleg10276632bootleg
brooklet1456402brooklet
footle93914382footle_
footled113610762footled
footler104011872footler
footles103715712footles
frontlet1147652frontlet
hooklet142510812hooklet
moonlet92413272moonlet
outlet63728682_outlet
rooted75424002root_ed
rooter64926032root_er
rootier74915392rootier
rootiest83115592rootiest
rootless83910442rootless
tootle62613812tootle_
tootled83511042tootled
tootler73511122tootler
tootles72915602tootles
bomblet13412263bomblet
boodle93215033boodle_
boodled113410933boodled
boodler103312003boodler
boodles103416043boodles
booklets14247123booklets
boomlets12246673boomlets
booted94822733boot_ed
bootee84323023boot_ee
bootees94114473bootees
bootie85421163bootie_
booties94124613booties
bootlegs11325873bootlegs
bootless103410983bootless
bottle84916073bottle_
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
bractlet1239283bractlet
brooklets1543683brooklets
collet84030363_collet
cooled95224593coo_led
cooler84824713coo_ler
coolest9318643coo_lest
cooter85128613coot_er
cootie84223093cootie_
cooties93725733cooties
corslet9318063corslet
couplet114717943couplet
crosslet1049593crosslet
cutlet84924363_cutlet
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
dottle74212503dottle_
dottles83912283dottles
doublet103914033doublet
drooled9369203droo_led
droplet10312113droplet
flatlet10312253flatlet
fooled104317823foo_led
footed104418623foot_ed
footer94320773foot_er
footie94718143footie_
footier104115113footier
footies103721543footies
footiest113514913footiest
footlers113910793footlers
footless113710803footless
footmen1246583footmen
footrest11308853footrest
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
froglet11310063froglet
frontlets1244233frontlets
fruitlet1146883fruitlet
gantlet83616243gantlet
goblet93219483_goblet
goglet84618583_goglet
hooklets15217203hooklets
hooted104422663hoot_ed
hooter94123933hoot_er
hootier104915353hootier
hootiest113115643hootiest
hostler103411023hostler
howlet123518343_howlet
jostle13319863jostle_
jostled15267083jostled
jostler14288223jostler
jostles143411143jostles
looted74421113loot_ed
looter64222323loot_er
mantlet93620993mantlet
martlet93419153martlet
mooley11311633moo_ley
moonlets10247473moonlets
moonlit9229333moonlit
moonset92413043moonset
mooted94120373moot_ed
mooter83921093moot_er
motet75641193_mot_et
motley1139383_motley
mottle84116053mottle_
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
nutlet64220563_nutlet
octet7324063_oct_et
omelet8317073_omelet
oodles73517183_oodles
ostler63312193_ostler
outled74020343_outled
outlets73616363_outlets
outset64027453_outset
owlet83324463__owlet
partlet92720363partlet
piolet83225643pio_let
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
pottle84416103pottle_
pottles93816983pottles
rattle64717613rattle_
rattled84012953rattled
rattler74012743rattler
rattles73217303rattles
reflet94024233r_eflet
reglet73724233r_eglet
relet54749823r__elet
reoiled84316853reoiled
riblet84222443r_iblet
rillet64828853r_illet
ringlet82818173ringlet
rioted73416373riot_ed
rioter64817283riot_er
ripplet113412583ripplet
rivulet1069723rivulet
roble75223023r_oble_
robles85321693r_obles
rochet115423003r_ochet
rocket125425283r_ocket
roiled74320053r_oiled
role45851823r_o_le_
roles56747983r_o_les
rolled74220243r_olled
roller63919793r_oller
rondelet9410353rondelet
rontgen835173rontgen
roofed105214743roo_fed
roofer94415283roo_fer
roofie93411173roofie_
roofies103014413roofies
roofless11316733roofless
rooftree1163353rooftree
rooked114918143roo_ked
rookie103613263rookie_
rookier114012383rookier
rookies113917103rookies
rookiest122912173rookiest
roomed95218543roo_med
roomer84718633roo_mer
roomie83013873roomie_
roomier93812243roomier
roomies93017243roomies
roomiest102611993roomiest
roose56127093roo_se_
roosed75621593roo_sed
rooser63921883roo_ser
rooses65526233roo_ses
roost55730933roo__st
roosted83211883roosted
rooster74415173rooster
root45655923roo___t
rootage839053rootage
rootages939103rootages
rootcap1143973rootcap
rooters74522933rooters
rooting83522433rooting
rootlike1236613rootlike
rootling9269953rootling
roots55933673root__s
rooty86423023root__y
roquet154415893r_oquet
roset55945243r_o_set
roster64329083rost_er
rotate63320343r_otate
rote46249023r_ot_e_
rotes56143903r_ot_es
rotgut738793r_otgut
rotl45029683r_otl__
rotls55620163r_otl_s
rotte54625933r_otte_
rotted74524433r_otted
rotten64115433r_otten
rotter64325463r_otter
rottes64524833r_ottes
rouble83913313rouble_
roubles93413513roubles
roundlet9209223roundlet
roupet84218343r_oupet
route55132073rout_e_
routed75624333rout_ed
router65025843rout_er
routes66129313rout_es
roweled11269863roweled
rundlet83114153rundlet
runlet63821413r_unlet
rustle63615413rustle_
rustled83311323rustled
rustler73512343rustler
rustles73416413rustles
sooted73922593soot_ed
soothe94214853soothe_
soothed113712743soothed
soother104215043soother
soothes103917113soothes
soothest113312243soothest
sootier73916613sootier
sootiest84016753sootiest
spotlit947303spotlit
tartlet72218483tartlet
toilet66228093_toilet
tonlet62924703_tonlet
tooled74918903too_led
tooler63818613too_ler
tooted74620123toot_ed
tooter64420803toot_er
toothed113310243toothed
tootlers8289503tootlers
tootses72910773tootses
townlet1049733townlet
triolet73219523trio_let
violet92620923vio_let
woodlot1147023woodlot
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolled1136643woolled
woollen1034723woollen
wristlet1138643wristlet
zooglea1733373zooglea
zootier163611173zootier
zootiest173311213zootiest

Search took 10 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.436409841.7
2DLD Change Limit1340272578.56315651.9
3Display Results2572570.0932763.4
 (SQL Overall)1786912579.09219653.7
 
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.