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

151 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
thrashed155536(None) 
thrasher1455741thrasher
thrashes1487651thrashes
threshed1535641threshed
trashed113514701t_rashed
crashed134214202_crashed
hashed136021942_h_ashed
phrased1387382phras_ed
thralled1245802thralled
thrash12258362thrash__
thrashers1565312thrashers
thrawed1435582thra_wed
thresher1455822thresher
threshes1437382threshes
thrushes1436522thrushes
thrusted1265222thrusted
trasher104416132t_rasher
trashes104119262t_rashes
abashed1357663_abashed
airshed11258533air_shed
arrased8149863arras_ed
ashed97829773___ashed
bashed126225703__bashed
brasher124515243_brasher
brashes124518463_brashes
brassed103612373_brassed
brushed133811213_brushed
cashed125124353__cashed
chased125019293ch_as_ed
chasmed154710173ch_asmed
chassed134712133ch_assed
cherished1865193cherished
clashed133614013_clashed
crasher124616163_crasher
crashes124618403_crashes
crushed134111963_crushed
dashed115920563__dashed
deashed123411303_deashed
encashed14246473encashed
erased74816753_eras_ed
fashed136720253__fashed
flashed144112183_flashed
freshed143312593_freshed
gashed116321973__gashed
gnashed12317523_gnashed
graphed1498473_graphed
grasped11409063_grasped
grassed93812793_grassed
harassed1237113harassed
harshen1339283_harshen
harsher13310363_harsher
hashes125024803_h_ashes
hasped125014443_h_asped
hasted105125283_h_asted
hushed134416673_h_ushed
kurbashed1982563kurbashed
lashed105625213__lashed
leashed113211163_leashed
mashed125325043__mashed
pashed125923143__pashed
perished14310073perished
phased124011973ph_as_ed
phrase11109903phras_e_
phrases12711463phras_es
plashed133712643_plashed
quashed20207973_quashed
rased65033933__ras_ed
rasher95024123__rasher
rashes95330153__rashes
rasped94715203__rasped
rehashed1536063rehashed
rewashed1546243rewashed
rushed104419863__rushed
sashed105622943__sashed
sheathed1547223sheathed
shushed14348493sh_ushed
slashed114114853_slashed
smashed133711223_smashed
splashed1435593splashed
squashed21215983squashed
stashed113812493_stashed
swashed144311363_swashed
tarnished13196063tarnished
tasked114714643t__asked
tasted74123973t__asted
teased74721153t_eas_ed
thacked173810203th_acked
thanked15469153th_anked
thatched1735433thatched
thawed13458463th_a_wed
thighed1535273th_ighed
thirsted1235213thirsted
thrashing1635673thrashing
thrave126010273thra_ve_
thraves13469713thra_ves
threaded1366323threaded
threaped1454863threaped
threated1259203threated
threeped1454373threeped
thresh12276863thresh__
threshers1545423threshers
threshold1642913threshold
thrilled1235493thrilled
thrived14458183thr_ived
throated1247923throated
throbbed1643163throbbed
throned115412173thr_oned
thronged13405333thronged
thrummed1642843thrummed
thrush12257483thrush__
thruster1135793thruster
thwacked2132723thwacked
thwarted1533363thwarted
toasted84011923t_oasted
toolshed1244213toolshed
torched133511353tor_ched
traced94821583t_ra_ced
trachea12311673t_rachea
tracheid1437583t_racheid
trachled1438313t_rachled
tracked143716133t_racked
traded85717683t_ra_ded
traiked123310453t_raiked
trailed83415673t_railed
trained84117203t_rained
trammed123810713t_rammed
tramped124312433t_ramped
tranced104414173t_ranced
trapped124512213t_rapped
trash86119763t_rash__
trashers113013643t_rashers
trashier113210103t_rashier
trashmen1346563t_rashmen
trashy12509053t_rash_y
trasses74819323t_rasses
trawled113411523t_rawled
tressed83714253t_ressed
trothed114010973t_rothed
trussed84010013t_russed
trusted83412783t_rusted
trysted11428273t_rysted
tushed104615893t__ushed
uncashed14299763uncashed
unlashed12289183unlashed
unrushed12247573unrushed
unwashed15288483unwashed
uprushed14234473uprushed
washed135521503__washed
whished17428023wh_ished
whooshed1833453whooshed
wrathed14298523_wrathed

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.1561145455.1
2DLD Change Limit1461621517.29620033.2
3Display Results1511510.0801887.5
 (SQL Overall)1786911517.53223724.2
 
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.