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 “gamas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

231 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
gamas8543135(None) 
agamas97413441agamas
agmas85919871agmas
amas67746291_amas
camas96333521camas
galas65731641galas
gama77035511gama_
gamay116419101gamay
gamays126310901gamays
gambas115817511gambas
gambs105721121gambs
games86238551games
gammas115714691gammas
gamps105323711gamps
gams76648881gam_s
gramas94317201gramas
lamas75532791lamas
mamas95930771mamas
aas310975392_a_as
abas68642082_abas
agama85815572agama_
agas55938842_agas
aghas97014872aghas
agma77623262agma_
alas46358122_alas
almas76629772almas
ama510853302_ama_
amah98927482_amah
amahs107819062_amahs
amass77119682_amass
amias75831462_amias
amis66445312_amis
amps86230342_amps
amus65529612_amus
anas46649862_anas
atmas75721012atmas
baas66844672ba_as
babas96325732babas
balas76937212balas
bams87044452bam_s
bemas96424282bemas
bimas95521742bimas
cacas95627982cacas
camass104114182camass
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282cam_s
casas75327842casas
comas95833002comas
cymas126417882cymas
dadas75819862dadas
daman84821162daman
damans94715982damans
damar84117732damar
damars93814992damars
damask1335842damask
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
dramas95814652dramas
dumas85420432dumas
fames105735922fames
favas115618592favas
gabs76740422ga_bs
gadis74825292gadis
gads67843382ga_ds
gaes56348032ga_es
gaffs124914652gaffs
gaga66625552gaga_
gages74529972gages
gagman103811242gagman
gags66441062ga_gs
gains65729512gains
gaits65726012gaits
gala55635162gala_
galah95917622galah
galahs105512672galahs
galax135314462galax
galeas74618502galeas
gales65442482gales
galls64729322galls
gals57946502ga_ls
gam67060062gam__
gamb96331842gam_b
gamba106018512gamba
gambe106219212gambe
gambes116318312gambes
gambias125010722gambias
game76644322gam_e
gamed95126392gamed
gamer84928942gamer
gamers94420822gamers
gamest94919922gamest
gamey115320552gamey
gamic103916192gamic
gamin84422992gamin
gamins94420042gamins
gamma106116102gamma
gammy135514892gammy
gamp98833212gam_p
gamut8322982gamut
gamuts958782gamuts
gamy105427532gam_y
gangs76222572gangs
ganjas14149112ganjas
gaols66717572gaols
gapes86030822gapes
gaps76042972ga_ps
garbs86321412garbs
gars55750742ga_rs
gas48870252g__as
gases65633992gases
gasman92911742gasman
gasps85415482gasps
gasts66628632gasts
gates65939502gates
gats56753442ga_ts
gauds75717722gauds
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
gawks136811632gawks
gawps115911012gawps
gayal9312712gayal
gayals1039512gayals
gays87338022ga_ys
gazar154612982gazar
gazars164811552gazars
gazes155425912gazes
gems75329112gem_s
getas65421482getas
gigas75415582gigas
gimps105915202gimps
glams85822932glam_s
glias64618492glias
goas55239942g_oas
grama85620282grama_
grammas12499772grammas
grampas12399252grampas
gramps114114272gramps
grams85327312gram_s
guavas1037152guavas
gummas114810512gummas
gums75030942gum_s
gyms107514592gym_s
hahas117118442hahas
halmas117017892halmas
hamal104623102hamal
hamals114816812hamals
hames106138702hames
hams96446132ham_s
hamzas20119012hamzas
iambs95815052iambs
jambs166014622jambs
jams135231072jam_s
javas155915422javas
kaas86531842ka_as
kakas85117342kakas
kames115024692kames
kanas95326912kanas
kapas116021732kapas
karmas123013732karmas
katas95922092katas
kavas125919952kavas
lama66635292lama_
lambs95921412lambs
lames75445542lames
lamias85020612lamias
lampas106615952lampas
lamps95624832lamps
lams66552262lam_s
lavas85422222lavas
limas75627632limas
llamas888972llamas
lumas75622912lumas
magmas115512502magmas
mama86231582mama_
mambas125716242mambas
mammas94616402mammas
manas76240422manas
maras75443282maras
mas58175812__mas
masas75630412masas
mayas105924382mayas
nadas66320812nadas
nalas55528362nalas
names74833362names
nanas55928632nanas
napas75924352napas
nemas75321572nemas
nomas74726412nomas
ogams84112682ogam_s
pacas96029402pacas
pampas124913992pampas
pams85641762pam_s
papas94927492papas
paras76143042paras
pimas94725102pimas
pumas95121562pumas
ragas65326062ragas
raias54631122raias
rajas127317722rajas
ramal74622242ramal
ramps96224632ramps
rams65950772ram_s
ramus76418282ramus
rayas85922052rayas
sagas66025882sagas
sambas104219262sambas
samps96124672samps
shamas113717932shamas
simas75727552simas
somas76030372somas
takas95520682takas
talas55935892talas
tamal73522612tamal
tamals84116622tamals
tames75242012tames
tamis76728722tamis
tamps95524082tamps
tams67247932tam_s
tapas74627712tapas
ulamas8910452ulamas
vamps125415482vamps
varas86028192varas
wames106432802wames
wamus105514682wamus
yams95330732yam_s
zamias174212922zamias

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 Filter178691538000.330541487.9
2DLD Change Limit538002314.79611217.7
3Display Results2312310.2031137.9
 (SQL Overall)1786912315.32933531.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.