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

196 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
refresh133545(None) 
afresh1255502_afresh
fresh115012202__fresh
redress82511872redress
refers93921082refers_
refires104820312refires_
reforest1139962reforest
refreshed1685612refreshed
refreshen1585162refreshen
refresher15104652refresher
refreshes1595952refreshes
refries104419732refries_
regress82711452regress
repress92712682repress
bearish123013273bearish
befret11315963befre_t
befrets1237613befrets
ceres75540013ce_res_
creesh11328333cre__esh
dearest83618673dearest
defers105116943defers_
deffest14308803deffest
defies104624053defies_
deforest1238793deforest
defrost1139553defrost
deftest112611713deftest
depress10239873depress
egress73310433_egress
enmesh1134893_enmesh
eyres84921773_eyres_
feres86038183fe_res_
flesh115013743__flesh
freres94716173fre_res_
frosh115713403__frosh
genres75515623genres_
heiress1036813heiress
heres86245903he_res_
heresy125011233he_resy
jefes155613673jef_es_
leftest10269463leftest
leftish13197253leftish
meres75143573me_res_
merest84725113me_rest
metres85121563metres_
nearest73415843nearest
peeress939503peeress
peres76246643pe_res_
perish114619063pe_rish
precrash1544823precrash
prefers123713333prefers_
prefires134313283prefires_
prepress12137983prepress
raffish1658843raffish
rares55247443r_ares_
rarest65725483r_arest
reales64934123reales_
realest73322433realest
reared75930013reare_d
rearer64928913reare_r
rearers74323563rearers
rearms85114653rearms_
rearrest8311603rearrest
rears54739653rear_s_
reaves94127573reaves_
rebbes10313533rebbes_
rebores95319163rebores_
rebred95816353rebre_d
rebreed104611073rebreed
recces10614913recces_
recess8314263re_cess
recross989833recross
reddest9311953reddest
reddish1238033reddish
redes65139123re_des_
redfish1437793redfish
redness82012443redness
redoes74623753redoes_
redream10107913redream
redrew10309503redre_w
redries83721713redries_
redyes104214083redyes_
reefers103312593reefers_
reefiest112811483reefiest
reerect92915883reerect
rees45364193re__es_
reest54938093re__est
reeves94721493reeves_
refaces123216743refaces_
refect114319333ref_ect
refed93921923ref_e_d
refeed104717623ref_eed
refeeds11368973refeeds
refeel93913243ref_eel
refeels10379693refeels
refel84920813ref_e_l
refell94214443ref_ell
refels94618053ref_els
refelt94521423ref_elt
refer84822143ref_e_r
referee101615753referee
refereed12149693refereed
referees111310413referees
referent112813423referent
reffed134712513reffe_d
refiles104122423refiles_
refines105426343refines_
refinish1447893refinish
refire95419473refire__
refired115116993refire_d
refits94017653refits_
refixes174813173refixes_
reflect123913713reflect
reflet94024233refle_t
reflets103513153reflets
reflew12389453refle_w
reflex16359513refle_x
reflies104418533reflies_
reforests1245533reforests
reforges12249333reforges_
reforms1239813reforms_
refract121311603refract
refrain10310043refrain
reframe1239393reframe
reframes1338993reframes_
refreeze2063263refreeze
refreshens16113993refreshens
refreshers16103673refreshers
refreshing1746063refreshing
refried113513873refried
refront10313263refront
refroze1956223refroze
refry114412463refr__y
refs75732243ref__s_
refuel93912623refue_l
refuels10399523refuels
refuges115413373refuges_
refurbish1743213refurbish
refurnish1543853refurnish
refuse94817513ref_use
refused115114443refused
refuser104912783refuser
refuses104918553refuses
refutes104515723refutes_
reges65628783re_ges_
regreen8309043regreen
regreet83015953regreet
regret73723533regre_t
regrets83212923regrets
regrew10388563regre_w
rehash1237433re_hash
rehires105016113rehires_
reifies104218283reifies_
reives95723043reives_
relies65036423relies_
relish93916953re_lish
renest64529713re_nest
rentes65431193rentes_
reprise92715043reprise
repros84216003repros_
request16311023request
reread71715433re_read
rerent63832453re_rent
rerise64325633re_rise
rerose63320843re_rose
resees63827483resees_
resh76523453___resh
reshes94124363reshes_
restress82511773restress
retest64028453re_test
reties65436193reties_
retires74726213retires_
retread849003retread
retreat7317533retreat
retrench1346283retrench
retries74129073retries_
retros63820193retros_
reuses66025523reuses_
reveres103621343reveres_
revers94529633revers_
reverse103913743reverse
reverso10367693reverso
revest94623603re_vest
revues9813903revues_
rewash1237673re_wash
rewires104717113rewires_
rexes124526953re_xes_
rifest93114583rif_est
rifles94217703rifles_
ruffes124112423ruffes_
searest73322023searest
seeress7311573seeress
seres55448893se_res_
serest64831613se_rest
serfish1348973serfish
thresh12276863_thresh
wearish132310153wearish

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.1531167915.0
2DLD Change Limit1340271966.91019396.1
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.13925030.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.