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

135 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
refloats115691(None) 
refloat10310831refloat_
floats96816252__floats
recoats92616642re_coats
redcoats1147122redcoats
reflags1156952refl_ags
reflate103516262refl_ate
reflates113115662refl_ates
reflects13288872reflects
reflets103513152refl_ets
refloated1347012refloated
refloods1245552refloods
reflows13258982reflo_ws
refronts1137772refronts
reloads8911312re_loads
reloans7313132re_loans
replots93412632replo_ts
afloat9315153_afloat_
becloaks1644933becloaks
beflags1355493befl_ags
befleas1236973beflea_s
bloats85215763__bloats
defats105114553def__ats
defeats113511233def_eats
deflate113613943defl_ate
deflates123013943defl_ates
defleas1147223deflea_s
deflects14336733deflects
defoams1336193def_oams
defrosts1244833defrosts
eclats8313033_ecl_ats
efforts1334703_efforts
flats86429743__fl_ats
float85928573__float_
floaty124210943__floaty
flotas94013003__flotas
flouts94315273__flouts
freeloads1343903freeloads
gloats74515423__gloats
hellcats1346323hellcats
helots95217703he_lo_ts
keelboats1542743keelboats
merlots92710123merlo_ts
offloads1542723offloads
outfloats1243573outfloats
peacoats1247833peacoats
pelotas9410723pe_lotas
preloads1157513pre_loads
readopts1146493readopts
readouts938903readouts
realgars934533realgars
realists83014843realists
reallots837993reallots
reblooms1244283reblooms
reboots93512093re_boots
recheats1339193recheats
reclads1049993recl_ads
recleans1037513recleans
recoals94214623re_coals
recoat84024273re_coat_
redcoat10410883redcoat_
redouts81411663re_douts
redroots937753redroots
reelects103110883reelects
refects124012743ref_ects
refights1555883refights
refits94017653ref__its
reflag1098083refl_a_g
reflated123514293refl_ated
reflect123913713reflect_
reflet94024233refl_et_
reflexes1865933reflexes
reflies104418533refl_ies
refloating14198323refloating
reflood1136363reflo_od
reflow12379653reflo__w
reflowed15126903reflowed
reflower14126843reflower
reflowers15125983reflowers
reflown13316213reflo_wn
refluxes1855183refluxes
refocus1236973ref_ocus
refolds11298953ref_olds
reformats1445713reformats
reforms1239823ref_orms
refracts13137383refracts
refront10313263refront_
refusals1164913refusals
refutals1165503refutals
reglets83512983regl_ets
regloss8218023reglo_ss
reglows11288843reglo_ws
reheats104513523re_heats
reknots1136783rekno_ts
relate64033633re_l_ate
relates73731433re_l_ates
relays94316753re_l_ays
relents74018503re_lents
relets64025673re_l_ets
relicts94414593re_licts
relists73817053re_lists
reload7413893re_loa_d
reloan6415693re_loa_n
relocate10713533re_locate
relocates11712933re_locates
relocks134411293re_locks
relooks114010723re_looks
relucts9369673re_lucts
repeats94316053re_peats
replans92814943repl_ans
replants102811243replants
replate93420053repl_ate
replates102919273repl_ates
replays12399763repl_ays
repleads11357213repleads
replot83818593replo_t_
replows12329703replo_ws
reports94916213re_ports
repots85621003re_po_ts
reseats74319583re_seats
reshoots11228413reshoots
reslate73520593resl_ate
reslates83619503resl_ates
resoaks1148973re_soaks
resorts74817193re_sorts
respots92912763respo_ts
retorts76016513re_torts
retreats8311413retreats
retroacts1146283retroacts
revolts1038893re_volts
rollouts8136733rollouts
rowboats1384843rowboats
sellouts837493sellouts
teflons1036543teflo_ns
zealots1636763zealo_ts

Search took 8 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.500357382.0
2DLD Change Limit1461621357.22020244.0
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.76623009.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.