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

137 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
reflood113636(None) 
refloods1245551refloods
beblood12106082beblood
fireflood1642742fireflood
flood95215602__flood
rebloom1145652rebloom
redwood1236512redwood
refloat10310832refloat
reflooded1443552reflooded
reflow12379652refl_ow
reflowed15126902reflowed
reflown13316212reflown
reflows13258982reflows
refold103812112ref_old
reload7413892re_load
relook104813742re_look
bebloods13115233bebloods
becloud1246293becloud
beefwood1743353beefwood
befool1137713bef_ool
begloom1255243begloom
blood85319523__blood
firefloods1752403firefloods
floods104511653__floods
floor84215233__floor
food86830573__f_ood
freeload1244733freeload
helloed113512423helloed
keloid11812613ke_loid
meloid9615993me_loid
offload1443203offload
overflood1644523overflood
oxblood1743603oxblood
preload1049813pre_load
pureblood1471943pureblood
reallot7312133reallot
realtor73611353realtor
reblend1036653reblend
rebloomed1453283rebloomed
reblooms1244283reblooms
rebook125213203re_book
reboot84119333re_boot
reclad9311873recl_ad
recolor978693recolor
recook125513923re_cook
record96117423re_cord
redroot8312903redroot
redwoods1345773redwoods
reeled74725533reel_ed
refaced133713573refaced
refed93921923ref__ed
refeed104717623ref_eed
refelled122810163refelled
reffed134712513ref_fed
refiled114318653refiled
refilled12278673refilled
refilmed14235813refilmed
refind104717073ref_ind
refined114720003refined
refired115116993refired
refixed183611153refixed
reflag1098083refl_ag
reflags1156953reflags
reflate103516263reflate
reflated123514293reflated
reflect123913713reflect
reflet94024233refl_et
reflets103513153reflets
reflew12389453refl_ew
reflex16359513refl_ex
reflexed1975243reflexed
reflies104418533reflies
refloated1347013refloated
refloats1156913refloats
reflooding1544053reflooding
reflower14126843reflower
reflux16315413refl_ux
refluxed1954343refluxed
refly113914563refl__y
refolded1337063refolded
refolds11298953refolds
reform11312703ref_orm
refound1157413refound
refried113513873refried
refront10313263refront
refroze1956223refroze
refuged125410873refuged
refund104810303ref_und
refused115114443refused
refuted114313803refuted
regloss8218023regloss
reglow10339403regl_ow
reglowed13125853reglowed
reglows11288843reglows
reglued936333reglued
regroom1077293regroom
relaid75518443re_laid
reland75920433re_land
relend76116453re_lend
relied74926233re_lied
reloads8911313re_loads
reloan6415693re_loan
relock124713523re_lock
relooked13236653re_looked
relooks114010723re_looks
remold93412973re_mold
replead10399003replead
repled93319773repl_ed
replied103914443replied
replot83818593repl_ot
replots93412633replots
replow114210343repl_ow
replowed14127563replowed
replows12329703replows
reproof1238783reproof
reroof9315003re_roof
reshod103012233re_shod
reshoed112212153reshoed
reshoot102513893reshoot
resod64720053re__sod
resold73915363re_sold
resoled84119283resoled
respond1039113respond
respool937633respool
retold73013753re_told
retook104313443re_took
retool63914483re_tool
reword106321403re_word
rifled104115003rifl_ed
rood56733003r___ood
seafloor1143323seafloor
seafood1146153seafood
selfhood1543793selfhood
serfhood1544293serfhood
teflon937453tefl_on
teflons1036533teflons
telford1145153telford

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271378.32616097.4
3Display Results1371370.0502740.0
 (SQL Overall)1786911378.53220943.6
 
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.