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

161 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
prewash153521(None) 
rewash1237671_rewash
eyewash1642582eyewash
preach133613922pre_ach
precast11314852precast
precrash1544822precrash
prewar114712582prewa_r
prewarm14479612prewarm
prewarn124410152prewarn
prewashed1843922prewashed
prewashes1744752prewashes
rehash1237432_rehash
areas55935773are_as_
arecas84817443arecas_
arenas65021993arenas_
arepas85515703arepas_
awash116613163__awash
brash106221563br__ash
breach134213723bre_ach
breast8319633bre_ast
breath113916263bre_ath
brewage1347183brewage
brewis11469983brewis_
brews105617073brew_s_
carwash1535993carwash
crash109120013cr__ash
crease85519573cre_ase
creasy114612303cre_asy
creesh11328333cre_esh
crews105917503crew_s_
deash95617243_de_ash
eyelash1344563eyelash
fresh115012203fre__sh
grease75416233gre_ase
greasy10419463gre_asy
greenwash1642403greenwash
greyish1435173greyish
hogwash1742713hogwash
krewes1337923krewes_
leash85519213_le_ash
newish1237903_newish
outwash13187613outwash
pash95638133p___ash
peach125422493p_e_ach
peas65755063p_e_as_
pease75231113p_e_ase
peevish1535783peevish
perish114619063p_erish
perkish16258823perkish
pesewas1236223pesewas_
pews95731533p_ew_s_
pietas84516503pietas_
plash104616563p__lash
pleach134211243ple_ach
pleas75627033ple_as_
please84315733ple_ase
plenish1239943plenish
plews105415353plew_s_
potash1138273p_otash
prase76128753pr__ase
prawns11509023prawns_
preachy17307313pre_achy
preact103220393pre_act
preamp1238993pre_amp
prearm104512353pre_arm
prebade12310283prebade
prebake1539093prebake
prebasal1244723prebasal
precasts1239453precasts
precava1445093precava
precess11310863precess
precis103416703precis_
precise113518173precise
predate10616893predate
predawn1335353predawn
predeath1447003predeath
predusk1443773predusk
preens85020113preens_
prees75937173pre_es_
prefab1336243prefa_b
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
pregame1239553pregame
prelacy1437583prelacy
prelate9519693prelate
prelaw1139103prela_w
premade12311443premade
preman104117453prema_n
premise113818553premise
premiss113513813premiss
prename11412643prename
preops104911943preops_
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepaste12139083prepaste
prepave14228873prepave
prepay13310313prepa_y
prepays1437483prepays
preps96220693pre_ps_
prerace11414123prerace
presa74319043pre__sa
presage10312293presage
presale9416353presale
prese75228383pre__se
press75425953pre__ss
prest75736353pre__st
prests84021263prests_
pretape113511623pretape
pretaste10139523pretaste
pretax152310193preta_x
pretest9517633pretest
prevail1238243prevail
previse123713793previse
prewarms15406733prewarms
prewarns13456943prewarns
prewashing1944943prewashing
preweigh1753683preweigh
prewire124311143prewire
prework164210913prework
preworn124711223preworn
prewrap14104973prewrap
prewraps15114053prewraps
prexes154915953prexes_
preys105717783pre_ys_
prezes173614693prezes_
primas104418103primas_
proas75028803pr_oas_
prowar114110943prowa_r
prowess1237903prowess
prowest12311533prowest
prowls115511083prowls_
prows106327013prow_s_
prudish1376563prudish
prutah1136583pruta_h
rash76039933_r__ash
rawish123012913_rawish
reach105123883_re_ach
recast83422773_recast
relish93916953_relish
repass84114703_repass
repast83520633_repast
resh76523453_re__sh
rewake135218463_rewake
rewan85623663_rewa_n
reward106017643_reward
rewarm115913493_rewarm
rewashed1546243_rewashed
rewashes1447033_rewashes
rewax155713923_rewa_x
shrewish1744743shrewish
swash116316753__swash
trash86119763tr__ash
trefah1235093trefa_h
trews86118893trew_s_
upreach1444693upre_ach
ureas55826013ure_as_
urease64516993ure_ase
wash106033813___wash
wreath124111193wre_ath

Search took 7 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.390458182.1
2DLD Change Limit1340271615.90622693.4
3Display Results1611610.0632555.6
 (SQL Overall)1786911616.35928100.5
 
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.