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

297 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
reroof931500(None) 
reproof1238781reproof
reroofs1037941reroofs
behoof1458682behoof
hereof123212372hereof
proof105221532_proof
rebook125213202rebook
reboot84119332reboot
recook125513922recook
redroot8312902redroot
regroom1077292regroom
relook104813742relook
reproofs1346062reproofs
reroll6412682reroll
reroofed1235872reroofed
rerose63320842rerose
retook104313442retook
retool63914482retool
roof75738832__roof
unroof9410192unroof
aero45435343aer_o_
aerobe8412403aerobe
aerosol747683aerosol
airproof1345133airproof
aloof83521573_aloof
bedroom1247083bedroom
befool1137713befool
betook12439603betook
broo65129823_broo_
brood84620243_brood
brook114717763_brook
broom95022213_broom
broos75126413_broos
cero66329453cer_o_
ceros74726073cer_os
cerous85821203cerous
cheroot12413693cheroot
coof96643273__coof
crook115217573_crook
croon75522783_croon
dewool1047403dewool
drool65416103_drool
droop85814823_droop
ebook114510803_ebook
enroot6615993enroot
ergo56420153_ergo_
ergot65422893_ergot
erode64520993_erode
eros45238453_er_os
erose55727273_erose
error53712233_error
errors63311313errors
feoff10711053fe_off
fervor1235643fervor
fireproof1743703fireproof
fireroom1346053fireroom
forehoof1746603forehoof
goof85436873__goof
groom85317983_groom
hereon93914363hereon
heriot9422343heriot
hero74635783her_o_
heroes94923823heroes
heroic113516923heroic
heroin94420593heroin
heron85025503her_on
herons94820543herons
heros84930863her_os
hoof106036583__hoof
jerboa1535633jerboa
karoo92519583karoo_
karoos102415803karoos
kerf115827463ker__f
kloof123812133_kloof
kroon94514483_kroon
legroom1076093legroom
loof78141053__loof
maroon83118203maroon
merlon83012353merlon
merlot83217603merlot
nerol51017813ner_ol
neroli61111153neroli
nerols6914883nerols
pereon83517453pereon
period9314983period
pernod9310453pernod
peroxy1838243peroxy
perron83216623perron
person83517873person
poof95541663__poof
prebook1557523prebook
preboom1348243preboom
precook1577803precook
precool1139013precool
prenoon9310043prenoon
preriot9316413preriot
prerock1536723prerock
prof96134663_pr_of
proofs114511683_proofs
racoon83814473racoon
ratoon64417373ratoon
reason62616333reason
reavow1235723reavow
rebloom1145653rebloom
rebody1238153rebody
reboil83814683reboil
rebooks134010513rebooks
reboots93512093reboots
rebop9313283re_bop
rebops10311433rebops
rebore86625643rebore
reborn810016953reborn
rebozo1737323rebozo
rebozos1835143rebozos
rebuff1437023rebuff
reckon123010543reckon
recoal84117973recoal
recoat84024273recoat
recock145112723recock
recode93618713recode
recoil84016723recoil
recoin84320293recoin
recolor978693recolor
recomb1238873recomb
recon75624243re_con
recons84922993recons
recooks134711233recooks
recopy1339043recopy
record96117423record
recork126315483recork
recoup10810373recoup
recross989833recross
recrown12257573recrown
recto74520803recto_
rector84019743rector
rectos85718783rectos
redo56029363re_do_
redock134311543redock
redoes74623753redoes
redon65424883re_don
redone74820053redone
redons75222183redons
redos65126763re_dos
redout71820253redout
redowa1038453redowa
redox134714233re_dox
redroots937753redroots
redrove11249423redrove
redtop937973redtop
redwood1236513redwood
reef74938213re__ef
ref66053293re___f
reflood1136363reflood
reflow12379653reflow
refold103812113refold
reform11312703reform
refront10313263refront
refroze1956223refroze
region74614903region
reglow10339403reglow
regosol844883regosol
regrooms1196013regrooms
regroove1243673regroove
regroup1095173regroup
regrow10309883regrow
regrown11237363regrown
regrows11269153regrows
reif76937653re__if
rejoin134012243rejoin
reknot10311733reknot
relief94419683relief
reload7413893reload
reloan6415693reloan
relock124713523relock
relooks114010723relooks
remold93412973remold
remora8414583remora
remote84222603remote
remove116115573remove
renown9369983renown
renvoi945863renvoi
reoil55321183re_oil
replot83818593replot
replow114210343replow
repo66027543re_po_
repoll8410793repoll
report85326013report
repos74725793re_pos
repose84121413repose
repot75132623re_pot
repots85621003repots
repour8310993repour
repro75315913repro_
reprobe112310133reprobe
repros84216003repros
reprove122911073reprove
rerack122513163rerack
reran57329103rer_an
reread71715433reread
reredos838633reredos
rerent63832453rerent
rerig64018483rer_ig
rerigs74014793rerigs
rerise64325633rerise
rerolls739943rerolls
reroofing1336863reroofing
reroute7313963reroute
rerun58722153rer_un
reruns66413743reruns
reshod103012233reshod
reshoe92816483reshoe
reshoot102513893reshoot
reshot93519633reshot
reshow123111433reshow
resoak10311093resoak
resod64720053re_sod
resods74116303resods
resold73915363resold
resole64624183resole
resorb84914343resorb
resort65728613resort
resow88217243re_sow
resown94112923resown
resows93915353resows
respool937633respool
respot83117633respot
restroom1047573restroom
retold73013753retold
retools73411023retools
retore67630763retore
retorn610923423retorn
retort66831143retort
retro55020953retro_
retros63820193retros
revoke135216243revoke
revolt9316223revolt
revote94917453revote
rewoke1339521213rewoke
rewon86920573re_won
reword106321403reword
rewore938030153rewore
rework136619783rework
reworn98122193reworn
rewove126420073rewove
rewrote1039113rewrote
rezone153814783rezone
ripoff1436433ripoff
rolf75134873__rolf
rood56733003__rood
roofs85321153__roofs
rook85532033__rook
room66235083__room
root45655923__root
roseroot859513roseroot
ruboff1435203ruboff
runoff1235413runoff
scroop10299773scroop
serf76340113ser__f
serif84132133ser_if
sermon8413553sermon
serosa6313023serosa
serous65023563serous
serow86720443ser_ow
serows96016393serows
servo84516683servo_
servos93812723servos
setoff1238913setoff
sheroot10414373sheroot
shroff1538503shroff
spoof105019013_spoof
strook10410303strook
sunroof1047053sunroof
tearoom939063tearoom
termor84412513termor
terror63811733terror
thereof13168063thereof
troop76417533_troop
trooz145016153_trooz
unroofs1035783unroofs
unroot6315553unroot
uproot8314123uproot
varoom11411413varoom
verso85314633verso_
versos93812803versos
vroom105312473_vroom
wareroom1346513wareroom
werwolf1644573werwolf
wetproof1643763wetproof
whereof16185463whereof
whoof144612693_whoof
woof106532423__woof
xerox1138623xer_ox
zero134822473zer_o_
zeroed16409413zeroed
zeroes154314343zeroes
zeros144918113zer_os
zeroth1837963zeroth

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.1261418182.5
2DLD Change Limit1127162976.28017948.4
3Display Results2972970.1102700.0
 (SQL Overall)1786912976.51627423.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.