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

102 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
squashers2118498(None) 
quashers20186801_quashers
squasher20185781squasher_
squashes20207801squashe_s
quasher19198622_quasher_
quashes192110972_quashe_s
shushers14267052shu_shers
slashers113313612s_lashers
smashers13339592s_mashers
splashers1445282splashers
squallers1834682squallers
squanders1934442squanders
squarers17338022squa_rers
squashed21215982squashe_d
squashier2143912squashier_
squatters1834942squatters
squawkers2542482squawkers
squishes20198392squishe_s
squushes20194672squushe_s
swashers14389532s_washers
bashers124820833__bashers
blushers133911293blu_shers
brushers134210573bru_shers
bushers124018803_bu_shers
clashers134213993_clashers
crashers134013233_crashers
crushers134010093cru_shers
dashers115016863__dashers
flashers143912653_flashers
flushers14279733flu_shers
gushers113512513_gu_shers
kashers143914023__kashers
lashers104121833__lashers
mashers124621053__mashers
mushers124016443_mu_shers
musquashes2451763musquashe_s
plashers133813453_plashers
pushers123814503_pu_shers
quaffers2333963_quaffers
quakers20309693_qua_kers
quarters173110453_quarters
quasars1646903_quas_ars
quashed20207973_quashe_d
quasses16209503_quasse_s
quavers19309013_qua_vers
questers17168763_questers
qurshes19228573_qurshe_s
rashers104020913__rashers
rushers103816103_ru_shers
sashes94728483s__ashe_s
scutchers16175643scutchers
sequesters1943843sequesters
sheathers1557553sheathers
shusher13288113shu_sher_
shushes133510303shu_she_s
slasher104515333s_lasher_
slashes103619113s_lashe_s
slathers113914783s_lathers
slushes103514413slu_she_s
smasher123911023s_masher_
smashes123914613s_mashe_s
smushes123710093smu_she_s
snashes105214753s_nashe_s
southers114214453sou_thers
splasher1335663splasher_
splashes1337503splashe_s
squabblers2341843squabblers
squaller1736083squaller_
squalors1744583squa_lors
squander1835533squander_
squarer163410663squa_rer_
squares163714463squa_re_s
squash1846833squash___
squashiest2244133squashiest
squashily2442793squashily
squashiness2342433squashiness
squashing2234703squashing
squashy2233843squash__y
squatness1844943squatness
squatter1735913squatter_
squawker2443093squawker_
squeakers2284113squeakers
squealers1894453squealers
squeezers2742553squeezers
squelchers2442163squelchers
squinters1835523squinters
squirmers2053113squirmers
squirters1835073squirters
squished21186393squishe_d
squishier2143383squishier_
squooshes2142543squooshe_s
squushed21193703squushe_d
stashes103916173s_tashe_s
sudsers83310423s_uds_ers
swasher134011513s_washer_
swashes134714403s_washe_s
swathers144512083s_wathers
swishers14328053s_wishers
thrashers1565313thrashers
trashers113013643_trashers
ushers94415533__u_shers
washers134517523__washers

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411027.28320409.3
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.74923059.9
 
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.