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

144 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
squander183553(None) 
squanders1934441squanders
sander74828532s__ander
slander84015452s_lander
solander948122solander
sounder83315392sou_nder
squadded2033842squadded
squalider1943842squalider
squaller1736082squaller
squandered2142722squandered
squanderer2052152squanderer
squarer163410662squa_rer
squasher20185782squasher
squatter1735912squatter
squawker2443092squawker
squinter1747362squinter
stander84316162s_tander
strander97112062strander
sunder74019832s_u_nder
asunder856233asu_nder
bander93928223__bander
bilander1136673bilander
blander103715173_blander
blunder103813163blu_nder
bounder104215543bou_nder
brander103915823_brander
colander1139033colander
dander811222993__dander
daunder9348903dau_nder
demander12238723demander
expander18145803expander
founder114312583fou_nder
funder104016093_fu_nder
gander84322763__gander
grander93315873_grander
guarder936463_guarder
hander104526433__hander
hounder113412243hou_nder
inlander937223inlander
islander946103islander
lander74028493__lander
launder8309153lau_nder
maunder10328693mau_nder
meander1049973_meander
oleander936403oleander
pander93725533__pander
plunder103810513plu_nder
pomander1347083pomander
pounder103314013pou_nder
quadded1934863_quadded
quaffer2235133_quaffer
quainter1765903_quainter
quaker193811623_qua_ker
quakier20239203_quakier
quandary2143433_quandary
quanted1738973_quanted
quarter163211863_quarter
quasher19198623_quasher
quaver18309313_qua_ver
rounder83514613rou_nder
sadder82916973s__adder
sanded84920613s__anded
sanders84025943s__anders
sandier84017843s__andier
saner54334323s__an_er
sanger74524573s__anger
saunter72913453sau_nter
scanner94411813s_canner
scanter94215183s_canter
scunner9358243scu_nner
seconder1137183seconder
sender73824413s__ender
sequencer2044573sequencer
shader104218763s_ha_der
shudder12297323shu_dder
shunner10358643shu_nner
shunter103611733shu_nter
skanker10268483s_kanker
slanders94014023s_landers
slender83413603s_lender
solanders1036963solanders
sonder73623523s__onder
sounded93214463sou_nded
sounders93214123sou_nders
spader94317133s_pa_der
spandex1735833s_pandex
spanker133612353s_panker
spanner94312563s_panner
spender103713693s_pender
spudder11256553spu_dder
spurner9269653spurn_er
squabbier2242753squabbier
squabbler2242733squabbler
squad155110793squa_d__
squads164410293squa_d_s
squalled1835943squalled
squallers1834683squallers
squallier1844363squallier
squalor1644423squa_lor
squamae1845723squamae_
squanderers2151423squanderers
squandering2242953squandering
square154513363squa_re_
squared173610563squa_red
squarers17338033squa_rers
squares163714463squa_res
squashed21215983squashed
squashers21184983squashers
squashes20207803squashes
squashier2143913squashier
squatted1835343squatted
squatters1834953squatters
squattier1843713squattier
squawked2543013squawked
squawkers2542483squawkers
squeaker2184883squeaker
squeakier2242903squeakier
squealer17115603squealer
squeezer2643373squeezer
squidded2043723squidded
squinnier1843033squinnier
squinted1847063squinted
squinters1835523squinters
squintier1844473squintier
squirmer1934373squirmer
squirter1746523squirter
staider83912613s_taider
standee83514513s_tandee
standers93514303s_tanders
stranded102710813stranded
stranders10389943stranders
stranger94715103stranger
stunner7349193stu_nner
stupider1133913stupider
suaver93014233s_ua_ver
sunders84120063s_u_nders
sundew10369693s_u_ndew
sunnier73412153s_unnier
swanker14369483s_wanker
thunder1136973thu_nder
under64624223__u_nder
uplander1145543uplander
wander104423713__wander
zander163417113__zander

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 Limit1461621447.12620511.1
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.60923484.2
 
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.