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

187 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
squashes2020780(None) 
quashes192110971_quashes
squashed21215981squashed
squasher20185781squasher
squashers21184981squashers
squishes20198391squishes
squushes20194671squushes
musquashes2451762musquashes
quashed20207982_quashed
quasher19198622_quasher
quashers20186812_quashers
quasses16209502_quasses
qurshes19228572_qurshes
sashes94728482s__ashes
shushes133510302shu_shes
slashes103619112s_lashes
slushes103514412slu_shes
smashes123914612s_mashes
smushes123710092smu_shes
snashes105214752s_nashes
splashes1337502splashes
squares163714462squa_res
squash1846832squash__
squashier2143912squashier
squashiest2244132squashiest
squashy2233842squash_y
squished21186392squished
squooshes2142542squooshes
squushed21193702squushed
stashes103916172s_tashes
swashes134714402s_washes
abashes12510373_abashes
ashes86230613___ashes
bashes115631393__bashes
blushes124314823blu_shes
brashes124518463_brashes
brushes124014663bru_shes
bushes115226113_bu_shes
calashes13310543calashes
cashes114729883__cashes
clashes124017283_clashes
crashes124618403_crashes
crushes124215133cru_shes
cuishes122810823_cuishes
dashes106124983__dashes
deashes113313903_deashes
emdashes14224303emdashes
encashes13227673encashes
endashes12217453endashes
equates162012323equa_tes
fashes124524023__fashes
flashes133916103_flashes
flushes134114143flu_shes
gamashes1456953gamashes
gashes105725153__gashes
gnashes11419573_gnashes
gouaches1436203gouaches
goulashes1343713goulashes
gurshes112210033_gurshes
gushes104719033_gu_shes
hashes125024803__hashes
hushes124718593_hu_shes
lashes94831003__lashes
lavashes1445573lavashes
leashes103514403_leashes
lushes94022743_lu_shes
mashes115030003__mashes
mushes114124563_mu_shes
oquassas1742113oquassas
pashes115828393__pashes
plashes124417393_plashes
plushes124313673plu_shes
potashes1337833potashes
pushes114621663_pu_shes
quaeres163310853_quaeres
quaiches2235343_quaiches
quakes194013343_qua_kes
quamashes2343973_quamashes
quartes163314943_quartes
quasars1646903_quasars
quash174512163_quash__
quass144413763_quas__s
quatres163411943_quatres
quiches2139333_quiches
qurushes2034943_qurushes
rashes95330153__rashes
rehashes1436953rehashes
rewashes1447033rewashes
rushes94724363_ru_shes
sadhes104715373s__adhes
sashed105622943s__ashed
sasses64124393s__asses
sausages937003sausages
scathes124515713s_cathes
sculches15176273sculches
scutches15168883scutches
sheathes14610193sheathes
shushed14348493shu_shed
shusher13288113shu_sher
shushers14267053shu_shers
skoshes14246253s_koshes
slashed114114853s_lashed
slasher104515333s_lasher
slashers113313613s_lashers
sloshes103811803s_loshes
slushed113611243slu_shed
smashed133711223s_mashed
smasher123911023s_masher
smashers13339593s_mashers
smooshes13206863smooshes
smushed13368233smu_shed
smutches15177273smutches
snathes104816493s_nathes
sneeshes1136513sneeshes
souses64229243sou_s_es
soutaches1446443soutaches
spathes125116533s_pathes
splashed1435593splashed
splasher1335663splasher
splashers1445283splashers
sploshes1336133sploshes
squabbles2243633squabbles
squabs17429323squa__bs
squadded2033843squadded
squads164410293squa__ds
squalenes1845763squalenes
squalled1835943squalled
squaller1736083squaller
squallers1834683squallers
squalls1647313squa_lls
squalors1744583squalors
squamae1845723squamae_
squamates2045593squamates
squamose1944273squamose
squamous1944673squamous
squander1835533squander
squanders1934443squanders
square154513363squa_re_
squared173610563squa_red
squarer163410663squa_rer
squarers17338033squarers
squarest17338223squa_rest
squarks20417183squa_rks
squashily2442793squashily
squashiness2342433squashiness
squashing2234703squashing
squatness1844943squatness
squats153712963squa__ts
squatted1835343squatted
squatter1735913squatter
squatters1834953squatters
squattest1844613squattest
squawbushes2851083squawbushes
squawfishes2952043squawfishes
squawked2543013squawked
squawker2443093squawker
squawkers2542483squawkers
squawks23294883squa_wks
squaws18438783squa__ws
squeezes2643823squeezes
squelches2343363squelches
squinches2344253squinches
squires163812843squ_ires
squish1838573squish__
squishier2143383squishier
squishiest2244323squishiest
squishy2244023squish_y
squooshed2241843squooshed
squush1833993squush__
stases64225563s_tas_es
stashed113812493s_tashed
strasses81311443strasses
sudses74114503s_uds_es
sushis9311183s_u_shis
susses64221053s_u_sses
swashed144311363s_washed
swasher134011513s_washer
swashers14389533s_washers
swathes134115513s_wathes
swishes133411373s_wishes
swooshes14185123swooshes
thrashes1487653thrashes
trashes104119263_trashes
tushes94319473_tu_shes
unlashes11238043unlashes
usquabaes2041553usquabaes
washes124425493__washes

Search took 9 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.453394461.4
2DLD Change Limit1461621877.61019206.6
3Display Results1871870.0802337.5
 (SQL Overall)1786911878.14321944.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.