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

163 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
gamashes145695(None) 
abashes12510372_abashes
amasses93912852_amasses
calashes13310542calashes
camases114216342camas_es
camasses12388972camasses
famishes1658282famishes
galoshes1236912galoshes
ganaches1437432ganaches
gashes105725152g__ashes
gnashes11419572g_nashes
lavashes1445572lavashes
mashes115030002__mashes
quamashes2343972quamashes
smashes123914612_smashes
tamashas13135682tamashas
abases85720773_abas_es
abashed1357663_abashed
admasses1135413admasses
amahs107819063_ama_h_s
amass77119683_amas__s
amassed10388633_amassed
amasser9418733_amasser
amassers10337843_amassers
amazes175613473_ama_zes
ambushes1535803_ambushes
amuses85117943_amus_es
apaches143411843_apaches
ashes86230613___ashes
baases85218013ba_as_es
badasses1136173badasses
bagasses1136313bagasses
balases93815433balas_es
banishes131812463banishes
bashes115631393__bashes
brashes124518463_brashes
camass104114183camas__s
camises114218463camis_es
carwashes1745783carwashes
cashes114729883__cashes
clashes124017283_clashes
crashes124618403_crashes
damages11511283dama_ges
damasked1643753damasked
damasks1435073damas_ks
danishes121710493danishes
dashes106124983__dashes
deashes113313903_deashes
earaches13411313earaches
emdashes14224303emdashes
encashes13227673encashes
endashes12217453endashes
enmeshes1345343enmeshes
famished1766023famished
fashes124524023__fashes
flashes133916103_flashes
galahs105512683gala_h_s
galaxes1538883gala_xes
galaxies1637173galaxies
galoshe1135413galoshe_
galoshed1334493galoshed
gamas85431363gama___s
gamays126310913gama__ys
gambades1435863gambades
gambadoes1542833gambadoes
gambes116318313gam__bes
gambles124016203gam_bles
gamboges1435653gamboges
games86238553gam___es
gamesmen1345113gamesmen
gamester1137323gamester
gamesters1236733gamesters
gametes10312253gam_etes
gamines103618463gam_ines
ganache1346223ganache_
garages9314113gara_ges
garfishes16167083garfishes
garnishes13198813garnishes
gases65633993g__as_es
gashed116321973g__ashed
gasher104320373g__asher
gashest114813413g__ashest
gasses75724783g__asses
gausses8308693ga_usses
gavages1237683gava_ges
gazaboes2043873gazaboes
girshes11248293g_irshes
glasses84414273g_lasses
gnashed12317523g_nashed
goloshes1236263goloshes
gouaches1436203gouaches
goulashes1343713goulashes
gramaries12128313gramaries
gramaryes1572883gramaryes
grasses84117343g_rasses
greases84816713greas_es
guanases936233guanas_es
gumshoes1444123gum_shoes
gurshes112210033g_urshes
gushes104719033g__ushes
gyrases11368313gyras_es
hamates122917683hama_tes
harasses11311033harasses
hashes125024803__hashes
immeshes1543933immeshes
inmeshes1345613inmeshes
kavasses1544303kavasses
lambastes13114693lambastes
lampases1267293lampas_es
lashes94831003__lashes
lavishes1457403lavishes
leashes103514403_leashes
maches134827233__maches
marishes13512553marishes
marshes123615373ma_rshes
mashed125325043__mashed
masher114123203__masher
mashers124621053__mashers
mashies12318253__mashies
masses85028713__masses
meshes115019443__meshes
moshes115222873__moshes
mushes114124563__mushes
panaches15310293panaches
parishes13314753parishes
pashes115828393__pashes
plashes124417393_plashes
potashes1337833potashes
quashes192110973_quashes
radishes1269463radishes
rashes95330153__rashes
ravishes1478043ravishes
rehashes1436953rehashes
rewashes1447033rewashes
saganashes1442223saganashes
samadhis1444253samadhis
samshus12125353sam_shus
sashes94728483__sashes
slashes103619113_slashes
smashed133711223_smashed
smasher123911023_smasher
smashers13339593_smashers
smushes123710093_smushes
snashes105214753_snashes
splashes1337503splashes
squashes20207803squashes
stashes103916173_stashes
stramashes1544043stramashes
swashes134714403_swashes
takahes1436173taka_hes
tamales93216153tama_les
tamasha12125433tamash_a
tamises92715973tamis_es
thrashes1487653thrashes
trashes104119263_trashes
unlashes11238043unlashes
unmeshes1346153unmeshes
vamoses1239143vamos_es
vanishes141610753vanishes
wampishes1944303wampishes
wamuses1237023wamus_es
washes124425493__washes
zymases21938333zymas_es

Search took 7 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.423422437.4
2DLD Change Limit1461621636.21623513.8
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.70226662.3
 
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.