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

241 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
reroofs103794(None) 
reproofs1346061reproofs
reroof9315001reroof_
proofs114511682_proofs
rebooks134010512rebooks
reboots93512092reboots
recooks134711232recooks
redroots937752redroots
regrooms1196012regrooms
relooks114010722relooks
reproof1238782reproof_
rerolls739942rerolls
reroofed1235872reroofed
retools73411022retools
roofs85321152__roofs
unroofs1035782unroofs
aerobes9311493aerobes
aerosols847213aerosols
airproofs1443353airproofs
bedrooms1345713bedrooms
befools1236433befools
behoof1458683behoof_
broods95416383_broods
brooks125813883_brooks
brooms104915873_brooms
broos75126413_broo_s
ceros74726073cer_o_s
cerous85821203cer_ous
cheroots1348193cheroots
coofs105924713__coofs
crooks124914413_crooks
croons85418423_croons
dewools1145593dewools
drools74412813_drools
droops95110963_droops
ebooks12358333_ebooks
enroots738713enroots
ergots74512373_ergots
erodes74819883_erodes
eros45238453_er_o_s
eroses65327053_eroses
errors63311313_errors
feoffs1163703fe_offs
ferrous1049803ferrous
fervors1336233fervors
fireproofs1852633fireproofs
firerooms1445403firerooms
forehoofs1844983forehoofs
goofs94821003__goofs
grooms94512523_grooms
hereof123212373hereof_
heriots10312063heriots
heroes94923823her_oes
heroics122912003heroics
heroins103518013heroins
herons94820543her_ons
heros84930863her_o_s
hoofs115721043__hoofs
jerboas1636163jerboas
karoos102415803karoo_s
kerfs125413573ker__fs
kloofs13386353_kloofs
kroons103711243_kroons
legrooms1185413legrooms
loofs85623783__loofs
maroons92615553maroons
merlons93311273merlons
merlots92710123merlots
nerolis71012773nerolis
nerols6914883ner_ols
nervous1037143nervous
pereons92815003pereons
periods10312243periods
pernods1038483pernods
perrons93115483perrons
persons93717013persons
poofs105222793__poofs
prebooks1656303prebooks
precooks1656763precooks
precools1237703precools
profs105120893_pr_ofs
proof105221533_proof_
racoons93912433racoons
ratoons73815473ratoons
reasons72514943reasons
reavows1335273reavows
reblooms1244283reblooms
reboils94111723reboils
rebook125213203reboo_k
reboot84119333reboo_t
rebops10311433re_bops
rebores95319163rebores
rebozos1835143rebozos
rebuffs1533403rebuffs
reckons13269653reckons
recoals94214623recoals
recoats92616643recoats
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recolors1078813recolors
recombs1336753recombs
recons84922993re_cons
recook125513923recoo_k
records105213923records
recorks134813023recorks
recoups1188843recoups
recross989833recross
recrowns13246143recrowns
rectors93520523rectors
rectos85718783recto_s
redocks14409933redocks
redoes74623773re_does
redons75222183re_dons
redos65126763re_do_s
redouts81411663redouts
redowas1138393redowas
redoxes15310883redoxes
redroot8312903redroo_t
redtops1037373redtops
redwoods1345773redwoods
reefs85121663re__efs
refloods1245553refloods
reflows13258983reflows
refocus1236973refocus
refolds11298953refolds
reforms1239823reforms
refronts1137773refronts
refs75732243re___fs
regions83613473regions
regloss8218023regloss
reglows11288843reglows
regosols944323regosols
regroom1077303regroo_m
regroove1243673regroove
regrooves1343863regrooves
regroups11104383regroups
regrows11269153regrows
reifs84819093re__ifs
rejoins143111383rejoins
reknots1136783reknots
reliefs10439433reliefs
reloads8911313reloads
reloans7313133reloans
relocks134411293relocks
relook104813743reloo_k
remolds10299703remolds
remoras9314073remoras
remotes94521613remotes
removes124514713removes
renowns10277833renowns
renvois1036503renvois
reoils64516873re_oils
replots93412633replots
replows12329703replows
repolls939053repolls
reports94916213reports
repos74725793re_po_s
reposes94021263reposes
repots85621003re_pots
repours9310233repours
reprobes121910293reprobes
repros84216003repro_s
reproves132011473reproves
reracks132310533reracks
rereads81512293rereads
reredos838633reredos
rerents73319423rerents
rerigs74014793rer_igs
rerises73525883rerises
reroll6412683rer_oll
reroofing1336863reroofing
rerose63320843rer_ose
reroute7313963reroute
reroutes8312223reroutes
reruns66413743rer_uns
reshoes102316033reshoes
reshoots11228413reshoots
reshows132510453reshows
resoaks1148973resoaks
resods74116303re_sods
resoles73823653resoles
resorbs95010523resorbs
resorts74817193resorts
resows93915353re_sows
respools1036253respools
respots92912763respots
restrooms1146033restrooms
retook104313443retoo_k
retool63914483retoo_l
retorts76016513retorts
retros63820193retro_s
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
rewords115413983rewords
reworks145113603reworks
rezones163213943rezones
ripoffs1543383ripoffs
rolfs84817123__rolfs
roods65125283__roods
roof75738833__roof_
rooks95325043__rooks
rooms75324683__rooms
roots55933673__roots
roseroots945293roseroots
ruboffs1543123ruboffs
runoffs1343013runoffs
scroops11288253scroops
serfs84922013ser__fs
serifs94017053ser_ifs
serious73616283serious
sermons9311783sermons
serosas7312663serosas
serous65023563ser_ous
serows96016393ser_ows
servos93812723servo_s
setoffs1334133setoffs
sheroots1137863sheroots
shroffs1634363shroffs
spoofs114011813_spoofs
sunroofs1144763sunroofs
tearooms1047843tearooms
termors94712773termors
terrors73112213terrors
troops85712783_troops
unroof9410193unroof_
unroots738563unroots
uproots937143uproots
varooms1248883varooms
versos93812803verso_s
vrooms11398713_vrooms
warerooms1445823warerooms
whoofs15457243_whoofs
woofs114918003__woofs
xeroses143612823xeroses
xerosis14249663xerosis
xeroxes13246443xeroxes
zeroes154314343zer_oes
zeros144918113zer_o_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272416.11021935.7
3Display Results2412410.0763171.1
 (SQL Overall)1786912416.59227107.3
 
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.