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

149 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
refloat1031083(None) 
refloats1156911refloats
afloat9315152_afloat
float85928572__float
recoat84024272re_coat
redcoat10410882redcoat
reflag1098082refl_ag
reflate103516262refl_ate
reflect123913712reflect
reflet94024232refl_et
refloated1347012refloated
reflood1136362reflood
reflow12379652reflo_w
reflown13316212reflown
reflows13258982reflows
refront10313262refront
reload7413892re_load
reloan6415692re_loan
replot83818592replo_t
becloak1545043becloak
beflag1265883befl_ag
beflea1147123beflea_
befleas1236973befleas
bloat75229923__bloat
defat95426693def__at
defeat103817163def_eat
deflate113613943defl_ate
deflea1037443deflea_
defleas1147223defleas
deflect13399973deflect
defoam1238563def_oam
defrost1139553defrost
eclat7523603_ecl_at
effort1238623_effort
flat77147823__fl_at
floats96816253__floats
floaty124210943__floaty
flota85315643__flota
flout86226203__flout
freeload1244733freeload
gloat65427683__gloat
hellcat12410173hellcat
helot85332683he_lo_t
keelboat1464333keelboat
merlot83217613merlo_t
offload1443203offload
outfloat1146243outfloat
peacoat11412913peacoat
pelota8612833pe_lota
preload1049813pre_load
readopt10410843readopt
readout8615513readout
realest73322433realest
realgar834873realgar
realia6314593realia_
realist73225383realist
reallot7312133reallot
reblent9614253reblent
rebloom1145663rebloom
reboant9315093re_boant
reboot84119333re_boot
recheat12415933recheat
reclad9311873recl_ad
reclean938523reclean
recoal84117983re_coal
recoats92616643re_coats
redcoats1147123redcoats
redout71820253re_dout
redroot8312903redroot
reelect911515633reelect
refect114319333ref_ect
refelt94521423ref_elt
refight1488873refight
refit84230063ref__it
reflags1156953reflags
reflated123514293refl_ated
reflates113115663refl_ates
reflects13288873reflects
reflets103513153reflets
reflew12389453refl_ew
reflex16359513refl_ex
reflies104418533reflies
refloating14198323refloating
refloods1245553refloods
reflowed15126913reflowed
reflower14126853reflower
refluent1147433refluent
reflux16315413refl_ux
refly113914563refl__y
refold103812113ref_old
refolds11298953refolds
reform11312713ref_orm
reformat1357653reformat
refract121311603refract
refronts1137773refronts
refroze1956223refroze
reft75141273ref___t
refusal1056893refusal
refutal1046943refutal
reglet73724233regl_et
regloss8218023regloss
reglow10339403reglo_w
reglows11288843reglows
reheat94423943re_heat
reknot10311733rekno_t
relate64033633re_l_ate
relax124817803re_l_ax
relay84424673re_l_ay
relent64431853re_lent
relet54749823re_l_et
reliant7319243re_liant
relict83623903re_lict
relist64628413re_list
relit55340683re_l_it
reloads8911313re_loads
reloans7313133re_loans
relocate10713533re_locate
relock124713523re_lock
relook104813743re_look
reluct83916113re_luct
repeat85127213re_peat
replan83215823repl_an
replant93318533replant
replate93420053repl_ate
replay113412923repl_ay
replead10399013replead
replots93412633replots
replow114210343replo_w
replows12329703replows
report85326023re_port
repot75132623re_po_t
resat55139683re__sat
reseat64131493re_seat
reshoot102513893reshoot
reshot93519633resho_t
reslate73520593resl_ate
resoak10311093re_soak
resort65728623re_sort
respot83117633respo_t
retort66831153re_tort
retreat7317533retreat
retroact10410003retroact
revolt9316223re_volt
rollout7811943rollout
rowboat1267983rowboat
sellout7313583sellout
teflon937453teflo_n
teflons1036543teflons
zealot15313473zealo_t

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271497.31018334.7
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.77922970.9
 
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.