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 “squashed” 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
squashed2121598(None) 
quashed20207971_quashed
squasher20185781squasher
squashes20207801squashes
squished21186391squished
squushed21193701squushed
quasher19198622_quasher
quashes192110972_quashes
sashed105622942s__ashed
shushed14348492shu_shed
slashed114114852s_lashed
slushed113611242slu_shed
smashed133711222s_mashed
smushed13368232smu_shed
splashed1435592splashed
squadded2033842squadded
squalled1835942squalled
squared173610562squa_red
squash1846832squash__
squashers21184982squashers
squashier2143912squashier
squashy2233842squash_y
squatted1835342squatted
squawked2543012squawked
squishes20198392squishes
squooshed2241842squooshed
squushes20194672squushes
stashed113812492s_tashed
swashed144311362s_washed
abashed1357663_abashed
ashed97829773___ashed
bashed126225703__bashed
blushed134411753blu_shed
brushed133811213bru_shed
bushed124822383_bu_shed
cashed125124353__cashed
clashed133614013_clashed
crashed134214203_crashed
crushed134111963cru_shed
dashed115920563__dashed
deashed123411303_deashed
encashed14246473encashed
equaled17166923equa_led
equalled1834863equalled
equated171910403equa_ted
fashed136720253__fashed
flashed144112183_flashed
flushed143310973flu_shed
gashed116321973__gashed
gnashed12317523_gnashed
gushed114816243_gu_shed
hashed136021943__hashed
hushed134416673_hu_shed
lashed105625213__lashed
leashed113211163_leashed
lushed104218723_lu_shed
mashed125325043__mashed
mushed124420843_mu_shed
musquashes2451763musquashes
pashed125923143__pashed
plashed133712643_plashed
pushed125017463_pu_shed
quacked2336793_quacked
quadded1934863_quadded
quaffed2334253_quaffed
quailed1737823_quailed
quaked203910033_qua_ked
quanted1738963_quanted
quash174512163_quash__
quashers20186803_quashers
quasses16209503_quasses
quested17168383_quested
qurshes19228573_qurshes
rehashed1536063rehashed
rewashed1546243rewashed
rushed104419863_ru_shed
sashes94728483s__ashes
sassed76116173s__assed
scathed134012643s_cathed
scutched16186893scutched
sheathed1547223sheathed
shusher13288113shu_sher
shushes133510303shu_shes
slasher104515333s_lasher
slashes103619103s_lashes
sloshed11329823s_loshed
slushes103514413slu_shes
smasher123911023s_masher
smashes123914613s_mashes
smooshed14185993smooshed
smushes123710093smu_shes
smutched16165923smutched
snashes105214753s_nashes
snowshed1534423snowshed
soughed123811623sou_ghed
soused74822983sou_s_ed
southed114313993sou_thed
spasmed12296993s_pasmed
spathed134013183s_pathed
splasher1335663splasher
splashes1337503splashes
sploshed1434323sploshed
squabbled2342563squabbled
squad155110793squa___d
squalid1737053squa_lid
squaller1736083squaller
squamae1845723squamae_
squander1835533squander
square154513363squa_re_
squarer163410663squa_rer
squares163714463squa_res
squashiest2244123squashiest
squashily2442793squashily
squashing2234703squashing
squatter1735913squatter
squawker2443093squawker
squeaked2283903squeaked
squealed1885353squealed
squeezed2743253squeezed
squegged2042893squegged
squelched2442593squelched
squibbed2283423squibbed
squidded2043723squidded
squiffed2433733squiffed
squinched2443083squinched
squinted1847063squinted
squired173710063squ_ired
squirmed2034173squirmed
squirted1845793squirted
squish1838573squish__
squishier2143383squishier
squishy2244023squish_y
squooshes2142543squooshes
squush1833993squush__
stashes103916173s_tashes
sudsed83911373s_uds_ed
sughed113610203s_u_ghed
sussed75015533s_u_ssed
swasher134011513s_washer
swashes134714403s_washes
swathed144611933s_wathed
swished14418843s_wished
swooshed15174273swooshed
thrashed1555363thrashed
trashed113514703_trashed
tushed104615893_tu_shed
uncashed14299763uncashed
unlashed12289183unlashed
unshed10313773__unshed
unwashed15288483unwashed
washed135521503__washed

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.1731032896.0
2DLD Change Limit1461621517.70318974.7
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.93922508.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.