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

288 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
squash184683(None) 
quash174512161_quash
squashy2233841squashy
squish1838571squish
squush1833991squush
aquas142412612aquas_
musquash2241602musquash
quasi144015022_quasi
quass144413762_quass
qursh174110842_qursh
sash77235302s__ash
shush113812542shu_sh
skuas95611732skuas_
slash84719682s_lash
slush85316572slu_sh
smash104814432s_mash
smush104410582smu_sh
snash84815672s_nash
splash1168822splash
squab163810732squa_b
squabs17429322squabs
squad155110792squa_d
squads164410292squads
squall1538002squall
squama1736532squama
square154513362square
squarish2047322squarish
squark19438112squark
squashed21215982squashed
squasher20185782squasher
squashes20207802squashes
squat143720142squa_t
squats153712962squats
squaw17368982squa_w
squawk22385372squawk
squaws18438782squaws
squishy2244022squishy
squoosh1962842squoosh
stash84916972s_tash
swash116316752s_wash
abash106016513_abash
aguish1059283aguish
aqua132813963aqua__
aquae142212713aqua_e
ash67944603___ash
awash116613163_awash
bash915240163__bash
bluish1159243bluish
blush105115313blu_sh
brash106221563_brash
brush105917473bru_sh
bush96630713_bu_sh
calash11312433calash
cash96636283__cash
clash106219033_clash
crash109120013_crash
crush106815993cru_sh
cuish10313173_cuish
dash87031633__dash
deash95617243_deash
emdash12244113emdash
encash11276943encash
endash10297123endash
equal1449823equa_l
equals1538693equals
equate152012463equate
fash107232293__fash
flash115716213_flash
fluish1239333fluish
flush115116073flu_sh
gash86833023__gash
gnash9449833_gnash
goulash1164273goulash
gursh94512333_gursh
gush85424003_gu_sh
hash106936503__hash
hush105224113_hu_sh
lash76539653__lash
lavash12597373lavash
leash85519213_leash
lush75327693_lu_sh
mash96039403__mash
mush94929123_mu_sh
oquassa1642063oquassa
pash95638133__pash
plash104616563_plash
plush105614713plu_sh
potash1138273potash
push95526623_pu_sh
qua124821973_qua__
quack203812503_quack
quad144618703_qua_d
quads154515843_quads
quaff201311353_quaff
quag144815943_qua_g
quags154613253_quags
quai134420393_qua_i
quaich2047693_quaich
quaigh1935463_quaigh
quail144314363_quail
quais144618393_quais
quake184114643_quake
quaky214310743_quaky
quale143617853_quale
qualm163511183_qualm
quamash2144293_quamash
quant143624813_quant
quare143920543_quare
quark184614123_quark
quart144027853_quart
quasar1536833_quasar
quashed20207973_quashed
quasher19198623_quasher
quashes192110973_quashes
quate144521413_quate
quay164618353_qua_y
quays174612043_quays
queasy1855173_queasy
quest144121323_quest
quoth173310353_quoth
qurush1835503_qurush
rash76039933__rash
rehash1237433rehash
rewash1237673rewash
rush76628183_ru_sh
sagas66025883sagas_
sass45035623s__ass
sauch104918773sau_ch
sauchs115112233sauchs
saugh95318403sau_gh
saughs104812053saughs
sauls55128123sauls_
saunas63915433saunas_
scubas103710223scubas_
scuds85116243scuds_
sculch13226213sculch
scums95017423scums_
scups95316653scups_
scutch13247083scutch
scuts74522523scuts_
seas45755273s_eas_
selah8319613sela_h
selahs9313213selahs
seraph114011163seraph
shah105627783s_ha_h
shahs115919513s_hahs
shaugh13287433shaugh
sheas86331793sheas_
sheath12412893sheath
sheesh1237813sheesh
shuls85319713shuls_
shuns85018143shuns_
shuts85622483shuts_
shwas116415103shwas_
sikas94617023sikas_
simas75727553simas_
skas85325713s_kas_
skosh12407273s_kosh
skua86113153skua__
slosh84514483s_losh
slubs74719533slubs_
slues54527173slues_
slugs64618563slugs_
slums74623433slums_
slurs54123373slurs_
slushy12417223slu_shy
sluts54523983sluts_
smoosh11236733smoosh
smutch13205843smutch
smuts75415713smuts_
snath86419803s_nath
sneesh945893sneesh
snubs75412553snubs_
snugs64913023snugs_
sobas74424253sobas_
socas74026183socas_
sodas64123543sodas_
sofas85320713sofas_
sojas124716393sojas_
somas76030373somas_
soras55041013soras_
souari6311383souari
sough95320463sou_gh
soughs105115623soughs
souks94820523souks_
souls55127363souls_
soups75322943soups_
sourish10310693sourish
sours55230503sours_
sous46947213sou_s_
souse56530773sou_se
south85223573sou_th
souths95216603souths
soyas84520913soyas_
spas67036723s_pas_
spasm94514173s_pasm
splashy1543553splashy
splosh1186543splosh
spuds85113673spuds_
spues75025383spues_
spurs74621523spurs_
squabby2343283squabby
squalid1737053squalid
squallish2143403squallish
squalls1647313squalls
squally1937673squally
squalor1644423squalor
squamae1845723squamae
squamose1944273squamose
squared173610563squared
squarer163410663squarer
squares163714463squares
squarest17338223squarest
squarks20417183squarks
squashers21184983squashers
squashier2143913squashier
squashily2442793squashily
squashing2234703squashing
squatly1946433squatly
squatty1964823squatty
squawbush2651313squawbush
squawfish2742263squawfish
squawks23294883squawks
squeak1935253squeak
squeaks2034523squeaks
squeaky2343083squeaky
squeal1538023squeal
squeals1636513squeals
squeamish2342653squeamish
squeg1588033squ_eg
squegs1675643squegs
squelch2152953squelch
squib163710503squ_ib
squibs17317453squibs
squid154211903squ_id
squids16409803squids
squill1537233squill
squinch2134833squinch
squint154214793squint
squire155912463squire
squirish2045113squirish
squirm17387673squirm
squirt153812933squirt
squished21186393squished
squishes20198393squishes
squooshy2381273squooshy
squushed21193703squushed
squushes20194673squushes
staph104314653s_taph
stoas55126023stoas_
strass67117223strass
strath93216373strath
stubs75016073stubs_
studs64415873studs_
stums75320083stums_
stuns54719493stuns_
stupas83910883stupas_
suave83519873s_uave
subah106015213s_ubah
subahs114512383subahs
subas74724073subas_
subs66037123s_ubs_
such96424813s_u_ch
suds56135293s_uds_
sudsy95010683s_udsy
sues46247653s_ues_
sugh86423443s_u_gh
sughs95313323s_ughs
suks85927123s_uks_
sumach135310113sumach
sums65837583s_ums_
suns45841903s_uns_
sups64834433s_ups_
suqs134319653s_uqs_
surah86823253s_urah
surahs94515543surahs
suras55336333suras_
sushi8310493s_u_shi
suss45229303s_u_ss
swath115920383s_wath
swish115114823s_wish
swoosh12195213swoosh
thrash12258363thrash
trash86119763_trash
tush74523903_tu_sh
unlash938793unlash
usques15126803usques_
wash106033813__wash

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162885.01622471.3
3Display Results2882880.0803600.0
 (SQL Overall)1786912885.48632572.2
 
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.