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

132 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
redroots93775(None) 
redroot8312901redroot_
bedrooms1345712bedrooms
breadroots1343772breadroots
enroots738712_enroots
reboots93512092re_boots
redcoats1147122redcoats
redouts81411652red_outs
redrafts1235602redrafts
redwoods1345772redwoods
refronts1137772refronts
regrooms1196012regrooms
reproofs1346062reproofs
reroofs1037942re_roofs
reshoots11228412reshoots
bedposts1343873bedposts
bedrocks1745333bedrocks
bedrolls1144673bedrolls
bedroom1247083bedroo_m
beetroots1144013beetroots
breadroot1245553breadroot_
brierroots1262403brierroots
cheroots1348193cheroots
defrosts1244833defrosts
disroots948623disroots
droits74314313__droits
drools74412813__drools
droops95110963__droops
enroot6615993_enroot_
ergots74512373_e_rgots
freeboots1444043freeboots
gadroons1037013gadroons
godroons1045363godroons
headrooms1555183headrooms
heriots10312063he_riots
legrooms1185413legrooms
merlots92710123me_rlots
mudrooms1344083mudrooms
outroots839873outroots
pedros9312183pedr_o_s
readopts1146483readopts
readouts938883readouts
reallots837983reallots
rearmost1047263rearmost
reblooms1244283reblooms
rebooks134010513re_books
reboot84119333re_boot_
recoats92616643re_coats
recooks134711233re_cooks
recross989833recr_oss
recrowns13246143recrowns
recruits1036563recruits
redacts10510943red_acts
redbaits1135903redbaits
redbones1137593redbones
redcoat10410883redcoat_
redirects12125103redirects
redocks14409933red_ocks
redoes74623753red__oes
redons75222183red__ons
redos65126763red__o_s
redoubts11153973redoubts
redout71820253red_out_
redowas1138393red_owas
redoxes15310883red_oxes
redpolls1144013redpolls
redraft11310573redraft_
redraws11218473redr_aws
redreams1195953redreams
redress82511873redr_ess
redries83721713redr_ies
redrills956083redrills
redrives122610393redrives
redrove11249423redr_ove
redtops1037373red_tops
redwood1236513redwoo_d
reerects10319923reerects
refloats1156913refloats
refloods1245553refloods
refracts13137383refracts
refront10313263refront_
regrafts1235303regrafts
regrants9310013regrants
regreets9287853regreets
regrets83212923regr_ets
regroom1077293regroo_m
regroove1243673regroove
regrooves1343863regrooves
regroups11104383regroups
regrows11269153regr_ows
regrowth1544033regrowth
regrowths1642433regrowths
reknots1136783re_knots
relooks114010723re_looks
replots93412633re_plots
reports94916213re_ports
repots85621003re__pots
reprints1039903reprints
reprobes121910293reprobes
reproof1238783reproo_f
repros84216003repr_o_s
reproves132011473reproves
rerents73319423re_rents
rerolls739943re_rolls
reroof9315003re_roo_f
reroute7313963re_route
reroutes8312223re_routes
reshoot102513893reshoot_
resmooth1343633resmooth
resmooths1442643resmooths
resorts74817193re_sorts
respools1036243respools
respots92912763re_spots
resprouts1174823resprouts
restrooms1146033restrooms
retools73411023re_tools
retorts76016513re_torts
retracts101111313retracts
retreats8311403retreats
retroacts1146283retroacts
retrofits1245353retrofits
retros63820193retr_o_s
revolts1038893re_volts
rewrote1039113rewr_ote
roots55933673___roots
roseroots945293roseroots
seaboots1047093seaboots
sheroots1137863sheroots
taproots1047253taproots
tearooms1047843tearooms
unroots738563_unroots
uproots937143_uproots

Search took 9 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 Filter1786911461620.313570897.8
2DLD Change Limit1461621327.60619216.7
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.98222386.7
 
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.