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

186 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
thrashes148765(None) 
thrashed1555361thrashed
thrasher1455741thrasher
thrashers1565311thrashers
threshes1437381threshes
thrushes1436521thrushes
trashes104119261t_rashes
brashes124518462_brashes
crashes124618402_crashes
hashes125024802_h_ashes
phrases12711462phras_es
rashes95330152__rashes
thrash12258362thrash__
thraves13469712thra_ves
threshed1535642threshed
thresher1455822thresher
threshers1545422threshers
trashed113514702t_rashed
trasher104416132t_rasher
trashers113013642t_rashers
trasses74819322t_rasses
abashes12510373_abashes
arrases71214543arras_es
ashes86230613___ashes
bashes115631393__bashes
braches144621223_braches
brasher124515243_brasher
brashest133511763_brashest
brasses93818353_brasses
brushes124014663_brushes
calashes13310533calashes
carwashes1745773carwashes
cashes114729883__cashes
cerastes101111093cerastes
charases131312763charas_es
chases115128233ch_as_es
chasses124017503ch_asses
cherishes1767563cherishes
choushes1637623choushes
clashes124017283_clashes
crases85532313_cras_es
crashed134214203_crashed
crasher124616163_crasher
crashers134013233_crashers
crushes124215133_crushes
dashes106124983__dashes
deashes113313903_deashes
earaches13411303earaches
emdashes14224303emdashes
encashes13227673encashes
endashes12217453endashes
erases64425403_eras_es
fashes124524023__fashes
flashes133916103_flashes
frasses104314513_frasses
freshes133515823_freshes
gamashes1456943gamashes
gashes105725153__gashes
girshes11248293gir_shes
gnashes11419573_gnashes
grasses84117343_grasses
gurshes112210033gur_shes
gyrases11368313gyras_es
harasses11311033harasses
harshen1339283_harshen
harshens1437603_harshens
harsher13310363_harsher
harshest14310193_harshest
hashed136021943_h_ashed
hastes95727073_h_astes
hushes124718593_h_ushes
inrushes1136273inrushes
kurbashes1883523kurbashes
lashes94831003__lashes
lavashes1445573lavashes
leashes103514403_leashes
marishes13512553marishes
marshes123615373mar_shes
mashes115030003__mashes
morasses1038903morasses
onrushes1135213onrushes
oraches124216473_oraches
parishes13314753parishes
pashes115828393__pashes
perishes13313753perishes
phases114618403ph_as_es
phrase11109903phras_e_
phrased1387383phras_ed
plashes124417393_plashes
potashes1337833potashes
prases84429023_pras_es
quashes192110973_quashes
qurshes19228573qur_shes
qurushes2034943qurushes
raphes115117453__raphes
rases55447213__ras_es
rasher95024123__rasher
rashers104020913__rashers
rashest103916873__rashest
rehashes1436953rehashes
reshes94124363__reshes
rewashes1447033rewashes
rhaphes1534703rh_aphes
rushes94724363__rushes
sashes94728483__sashes
sheathes14610193sheathes
shushes133510303sh_ushes
slashes103619103_slashes
smashes123914613_smashes
snashes105214753_snashes
splashes1337503splashes
squashes20207803squashes
stashes103916173_stashes
strasses81311443strasses
swashes134714403_swashes
taches114224173t__aches
takahes1436173taka_hes
tamashas13135683tamashas
tarbushes1444883tarbushes
tarnishes12188893tarnishes
tasses64826763t__asses
tastes64126423t__astes
teaches122718353t_eaches
teases65426273t_eas_es
teraohms1343703teraohms
terrases82111483terras_es
texases1437573texas_es
thanes94918983th_a_nes
thatches1637513thatches
theatres11298633theatres
therapies1447723therapies
theses96517973th_es_es
thoraces13118943thora_ces
thoraxes1896363thora_xes
thralled1245803thralled
thralls10299043thra_lls
thrashing1635683thrashing
thrashings1742783thrashings
thrave126010273thra_ve_
thrawed1435583thra_wed
thraws129211103thra__ws
threes97117323thr__ees
thresh12276863thresh__
thrives134611713thr_ives
throes97518673thr__oes
thrones105715843thr_ones
throstles1265903throstles
thrush12257483thrush__
thrusted1265223thrusted
thruster1135793thruster
thrusters1245333thrusters
thrusts10226523thrus_ts
thyrses1335023thyrs_es
tirades8311723tira_des
torahs95115643tora_h_s
torches123715433tor_ches
torsades937213torsades
torses64727953tor_s_es
toshes94520103t__oshes
traces85329933t_ra_ces
trachea12311673t_rachea
tracheas13410273t_racheas
trachles13311753t_rachles
trades75724503t_ra_des
trances93919643t_rances
tranches132915513t_ranches
trapes85024463t_ra_pes
trash86119763t_rash__
trashier113210103t_rashier
trashiest123110633t_rashiest
trashmen1346563t_rashmen
trashy12509053t_rash_y
trass56226473t_ras__s
traves94222743t_ra_ves
tresses73719543t_resses
troches123715343t_roches
trusses73813643t_russes
trystes10419993t_rystes
tushes94319473t__ushes
unlashes11238043unlashes
uprushes13194863uprushes
urases63723563_uras_es
washes124425493__washes
whishes16309443wh_ishes
whooshes1734423whooshes
wrasses103812593_wrasses

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.423422437.4
2DLD Change Limit1461621866.81321453.4
3Display Results1861860.0762447.4
 (SQL Overall)1786911867.31224438.0
 
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.