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

368 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
reboots9351209(None) 
rebooks134010511rebooks
reboot84119331reboot_
boots75837972__boots
ebooks12358332_ebooks
freeboots1444042freeboots
prebooks1656292prebooks
rebaits9312572rebaits
rebatos92913092rebatos
reblooms1244282reblooms
reboils94111712reboils
rebook125213202reboo_k
rebooted11248462rebooted
rebops10311422reb_ops
rebores95319162rebores
rebozos1835142rebozos
rebuts84015192reb_uts
recoats92616642recoats
recooks134711232recooks
redouts81411652redouts
redroots937752redroots
reknots1136782reknots
relooks114010722relooks
replots93412632replots
reports94916212reports
repots85621002re_pots
reroofs1037942reroofs
reshoots11228412reshoots
resorts74817192resorts
respots92912762respots
retools73411022retools
retorts76016512retorts
revolts1038892revolts
robots8313142rob_ots
roots55933672r__oots
rubouts937972rubouts
seaboots1047092seaboots
abbots1039283_abbots
aborts84916183_aborts
babools11319453babools
baboons113211073baboons
baboos103517013baboo_s
bareboats1345823bareboats
bebloods13115233bebloods
bebops1237623beb_ops
befools1236433befools
beknots1335083beknots
besots86415453be_sots
bhoots11459903_bhoots
blots75626173__blots
boats75635153__boats
bolts76232113__bolts
boobs96221993__boobs
books115729713__books
booms95427123__booms
boons75031913__boons
boors74325013__boors
boos67955033__boo_s
boost75132473__boost
boosts86115013__boosts
boot67759373__boot_
booth105522013__booth
booths115313793__booths
booty106125913__booty
borts76735453__borts
bots66453953__b_ots
botts75224863__botts
bouts75131313__bouts
cahoots1238473cahoots
ceboids1237653ceboids
cheroots1348193cheroots
cloots85113693_cloots
coots75636843__coots
debits94214493deb_its
debones103315113debones
debtors1038533debtors
debts86418373deb__ts
debuts93911753deb_uts
decocts1237833decocts
dehorts11379773dehorts
deports105012883deports
depots94716343de_pots
despots10319683despots
dewools1145593dewools
ebbets10376833_ebbets
ebons74316093_eb_ons
ebook114510803_eboo_k
enroots738713enroots
ergots74512373_ergots
escots84211743_escots
eyebolts1343483eyebolts
fireboats1446403fireboats
foots85528283__foots
forebooms1645333forebooms
freeboot1345933freeboot_
gaboons10289893gaboons
galoots82410793galoots
gemots93712153ge_mots
gumboots1344253gumboots
haboobs1495463haboobs
hardboots1544353hardboots
helots95217703he_lots
heriots10312063heriots
hoots84830243__hoots
iceboats1244963iceboats
jabots1538883jab_ots
kebobs14427283keb_obs
loots55431423__loots
merlots92710123merlots
moots75831663__moots
oots46446443___oots
preboils1267273preboils
prebook1557523preboo_k
preboom1348243preboo_m
precooks1656763precooks
precools1237703precools
presorts105311673presorts
rabatos93010893rabatos
rabats83116223rab_ats
rabbets11279423rabbets
rabbits11299863rabbits
racoons93912433racoons
ragouts838533ragouts
ratoons73815473ratoons
reacts83616603re_acts
readopts1146483readopts
readouts938883readouts
reallots837983reallots
reasons72514943reasons
reavows1335273reavows
rebait8320403rebait_
rebars84019823reb_ars
rebate84424103reb_ate
rebates95123173rebates
rebato83714683reb_ato
rebbes10313533reb_bes
rebecks15288013rebecks
rebecs103913673reb_ecs
rebels84518133reb_els
rebids94015523reb_ids
rebills93510623rebills
rebinds104511873rebinds
rebirth1244933rebirth
rebirths1343083rebirths
rebloom1145653rebloom
reboant9315093reboant
reboard10310763reboard
reboards1138773reboards
rebodies1139153rebodies
rebody1238153reb_ody
reboil83814683reb_oil
rebooked15226503rebooked
rebooting12139023rebooting
rebop9313283reb_o_p
rebore86625643reb_ore
rebored105015883rebored
reborn810016953reb_orn
rebottle1044343rebottle
rebottles1143873rebottles
rebound1058583rebound
rebounds1156023rebounds
rebozo1737323reb_ozo
rebs65733563reb___s
rebuffs1533403rebuffs
rebukes134210553rebukes
rebus75721113reb__us
rebuses94915293rebuses
rebut75927383reb_ut_
rebuys11428783reb_uys
recants93217093recants
recasts93413533recasts
recepts113010263recepts
recits83621353re_cits
reckons13269653reckons
recoals94214623recoals
recoat84024273recoat_
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recolors1078813recolors
recombs1336753recombs
recons84922993re_cons
recook125513923recoo_k
records105213923records
recorks134813023recorks
recounts1038773recounts
recoups1188843recoups
recross989833recross
rectors93520513rectors
rectos85718783recto_s
recuts83817373re_cuts
redacts10510943redacts
redbaits1135903redbaits
redbones1137593redbones
redcoats1147123redcoats
redocks14409933redocks
redoes74623753re_does
redons75222183re_dons
redos65126763re_do_s
redoubts11153973redoubts
redout71820253redout_
redowas1138393redowas
redoxes15310883redoxes
redroot8312903redroot_
redtops1037373redtops
redwoods1345773redwoods
reedits8511743reedits
reemits9611303reemits
reests64618893re_ests
refects124012743refects
refits94017653re_fits
reflets103513153reflets
refloats1156913refloats
refloods1245553refloods
reflows13258983reflows
refocus1236973refocus
refolds11298953refolds
reforms1239813reforms
refronts1137773refronts
regents83416543regents
regions83613473regions
reglets83512983reglets
regloss8218023regloss
reglows11288843reglows
regosols944323regosols
regrets83212923regrets
regrooms1196013regrooms
regrows11269153regrows
reheats104513523reheats
rejects163910693rejects
rejoins143111383rejoins
reknits1137073reknits
reknot10311733reknot_
relents74018503relents
relets64025673re_lets
relicts94414593relicts
relists73817053relists
reloads8911313reloads
reloans7313133reloans
relocks134411293relocks
relook104813743reloo_k
relucts9369673relucts
remeets93712413remeets
remelts93511493remelts
remints95117293remints
remits85622943re_mits
remolds10299703remolds
remoras9314073remoras
remote84222603re_mote
remotes94521613remotes
remounts1036373remounts
removes124514713removes
renests74014213renests
rennets75212633rennets
renowns10277833renowns
rents55935183re__nts
renvois1036503renvois
reoils64516873re_oils
repasts93611933repasts
repeats94316053repeats
repents93717623repents
replot83818593replot_
replows12329703replows
repolls939053repolls
report85326013report_
repos74725793re_po_s
reposes94021263reposes
reposits10310453reposits
repot75132623re_pot_
repours9310223repours
reproofs1346063reproofs
repros84216003repro_s
rerents73319423rerents
rerolls739943rerolls
reroof9315003reroo_f
reroute7313963reroute
reroutes8312223reroutes
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613re_sets
reshoes102316033reshoes
reshoot102513893reshoot_
reshot93519633reshot_
reshows132510453reshows
resifts10378703resifts
resists74414923resists
resits64725563re_sits
resmooth1343633resmooth
resmooths1442643resmooths
resoaks1148973resoaks
resods74116303re_sods
resojets1535343resojets
resoles73823653resoles
resorbs95010523resorbs
resort65728613resort_
resows93915353re_sows
respools1036243respools
respot83117633respot_
rests54935873re__sts
results739833results
retests73813853retests
retints74717013retints
retook104313443retoo_k
retool63914483retoo_l
retort66831143retort_
retros63820193retro_s
rets45352563re___ts
reverts104715043reverts
revests104413733revests
revets94022173re_vets
revokes144212503revokes
revolt9316223revolt_
revote94917453re_vote
revotes104716393revotes
rewets94617213re_wets
rewords115413973rewords
reworks145113593reworks
rewrote1039113rewrote
rezones163213943rezones
rheboks1634003rheb_oks
ribbons1136243ribbons
riblets93412553riblets
riboses9310443riboses
ribworts1345093ribworts
riots54922013r__iots
riposts9279403riposts
robot7325973rob_ot_
roods65125283r__oods
roofs85321153r__oofs
rooks95325043r__ooks
rooms75324683r__ooms
roost55730933r__oost
roosts64916323r_oosts
root45655923r__oot_
rooty86423023r__ooty
roseroots945293roseroots
rotos56027883r__otos
rots46454093r___ots
routs57133413r__outs
rowboats1384823rowboats
rubatos9278643rubatos
rubious938273rubious
ruboffs1543113ruboffs
rubout8313553rubout_
runouts737343runouts
ryots85313783r__yots
sabots8314693sab_ots
scoots85315933_scoots
seaboot9512333seaboot_
setouts74110333setouts
sexpots1636293sexpots
sheroots1137863sheroots
shoots94619343_shoots
slyboots1343373slyboots
snoots64216663_snoots
soots55536203__soots
sublots92410913sublots
taboos83815423taboo_s
teapots939053teapots
toots55331873__toots
unbolts9247803unbolts
unroots738563unroots
uproots937143uproots
webfoot1544213webfoot_
weblogs1334223weblogs
zealots1636763zealots

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.1701051123.5
2DLD Change Limit1340273688.73615341.9
3Display Results3683680.1232991.9
 (SQL Overall)1786913689.02919790.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.