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

137 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
squasher2018578(None) 
quasher19198621_quasher
squashed21215981squashed
squashers21184981squashers
squashes20207801squashes
squashier2143911squashier
quashed20207982_quashed
quashers20186812_quashers
quashes192110972_quashes
shusher13288112shu_sher
slasher104515332s_lasher
smasher123911022s_masher
splasher1335662splasher
squaller1736082squaller
squander1835532squander
squarer163410662squa_rer
squash1846832squash__
squashy2233842squash_y
squatter1735912squatter
squawker2443092squawker
squished21186392squished
squishes20198392squishes
squishier2143382squishier
squushed21193702squushed
squushes20194672squushes
swasher134011512s_washer
basher115123813__basher
blusher124113113blu_sher
brasher124515243_brasher
brusher123813003bru_sher
busher114922203_bu_sher
clasher124615513_clasher
crasher124616163_crasher
crusher124412323cru_sher
dasher104318983__dasher
flasher133914063_flasher
flusher133012273flu_sher
gasher104320373__gasher
gusher104115773_gu_sher
kasher134915033__kasher
lasher94824533__lasher
lusher93818763_lu_sher
masher114123203__masher
musher113820573_mu_sher
musquashes2451763musquashes
plasher124215033_plasher
plusher124010383plu_sher
pusher114318283_pu_sher
quaffer2235133_quaffer
quaker193811623_qua_ker
quakier20239203_quakier
quarter163211863_quarter
quasar1536833_quas_ar
quash174512163_quash__
quasses16209503_quasses
quaver18309313_qua_ver
queasier1734473_queasier
quester161410023_quester
qurshes19228573_qurshes
rasher95024123__rasher
rusher94019653_ru_sher
sashed105622943s__ashed
sashes94728483s__ashes
scutcher15176963scutcher
sequester1844443sequester
sheather1458233sheather
shushed14348493shu_shed
shushers14267053shu_shers
shushes133510303shu_shes
slashed114114853s_lashed
slashers113313613s_lashers
slashes103619113s_lashes
slather103816083s_lather
slushed113611243slu_shed
slushes103514413slu_shes
slushier1135983slu_shier
smashed133711223s_mashed
smashers13339593s_mashers
smashes123914613s_mashes
smushed13368233smu_shed
smushes123710093smu_shes
snashes105214753s_nashes
souther104116303sou_ther
splashed1435593splashed
splashers1445283splashers
splashes1337503splashes
splashier1443593splashier
squabbier2242753squabbier
squabbler2242733squabbler
squadded2033843squadded
squalider1943843squalider
squalled1835943squalled
squallers1834683squallers
squallier1844363squallier
squalor1644423squa_lor
squamae1845723squamae_
squanders1934443squanders
square154513363squa_re_
squared173610563squa_red
squarers17338033squa_rers
squares163714463squa_res
squashiest2244133squashiest
squashily2442793squashily
squashing2234703squashing
squatted1835343squatted
squatters1834953squatters
squattier1843713squattier
squawked2543013squawked
squawkers2542483squawkers
squeaker2184883squeaker
squeakier2242903squeakier
squealer17115603squealer
squeezer2643373squeezer
squelcher2342783squelcher
squinter1747363squinter
squirmer1934373squirmer
squirter1746523squirter
squish1838573squish__
squishy2244023squish_y
squooshed2241843squooshed
squooshes2142543squooshes
squooshier2251233squooshier
squush1833993squush__
stashed113812493s_tashed
stashes103916173s_tashes
suaver93014233s_ua_ver
sudser73511283s_uds_er
sudsier868783s_udsier
swashed144311363s_washed
swashers14389533s_washers
swashes134714403s_washes
swather134213603s_wather
swisher13369523s_wisher
thrasher1455743thrasher
trasher104416133_trasher
usher84517763__u_sher
washer124720393__washer

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.420425454.8
2DLD Change Limit1461621377.45319611.2
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.91922564.8
 
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.