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

140 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
getas6542148(None) 
betas75528761betas
etas46432271_etas
fetas85624401fetas
geta56627441geta_
gets55442481get_s
zetas145018161zetas
agitas7310592agitas
antas55432032antas
beats76042242beats
bemas96424282bemas
beta66234132beta_
beths105519222beths
bets67051442bet_s
bettas84913922bettas
botas75328782botas
centas85020702centas
cestas85018542cestas
cetes75731102cetes
degas75119162degas
deltas74414822deltas
devas96218882devas
ditas65923672ditas
eats47054872_eats
eras45441502_eras
eta35834192_eta_
eths76619522_eths
etnas54713932_etnas
eyas76427432_eyas
feats86432752feats
feta76528902feta_
fetal85623372fetal
fetes85630142fetes
fets75345942fet_s
fetus85816542fetus
galas65731642galas
gamas85431362gamas
gas48870252g__as
gates65939512gates
gats56753442gat_s
gear55934972ge_ar
gears64628692gears
gecks125117092gecks
geds66730812ge_ds
geeks104915842geeks
gees55647882ge_es
gelds75118342gelds
gels56836102ge_ls
gelts65924612gelts
gems75329112ge_ms
genes65133092genes
genoas74013622genoas
gens55740072ge_ns
gentes75324162gentes
gents65729612gents
genus65319832genus
gerah9315302gerah
gerahs1039412gerahs
germs85118872germs
gestes75721392gestes
gests66028812gests
get47467462get__
getup83410262getup
getups9346852getups
geums85414112geums
ghats95818612ghats
gigas75415582gigas
gites65630182gites
gits55744592git_s
glias64618492glias
gnats65217712gnats
goas55239942g_oas
goats65527302goats
goths96513002goths
greats76318392greats
guts56637252gut_s
heats85838402heats
heths116317782heths
hets75547202het_s
iotas54821112iotas
jetes124922842jetes
jets115834102jet_s
jotas125717442jotas
katas95922092katas
keas86337092ke_as
leas45954182le_as
lets47147942let_s
litas54923772litas
lotas55926302lotas
meats75034052meats
mesas76823202mesas
meta65932412meta_
metal75427382metal
metals84520882metals
metes74736212metes
meths105320232meths
metis75025902metis
neats55931902neats
nemas75321572nemas
nets45941532net_s
netts55320722netts
peas65755062pe_as
peats76140192peats
petal76526892petal
petals84719812petals
pets66248332pet_s
pietas84516502pietas
pitas77427672pitas
reatas64021012reatas
retag63618412retag
retags73414302retags
retax124517972retax
rets45352562ret_s
rotas54827722rotas
seas45755272se_as
seats54844342seats
seta45637312seta_
setae56026222setae
setal56430902setal
sets45549502set_s
setts55124322setts
tas38477102__tas
teas45851492te_as
teats55636812teats
tepas76521682tepas
teths85418512teths
tetras63017622tetras
tets45847462tet_s
texas126514932texas
thetas93011572thetas
utas45924952_utas
vestas95916682vestas
vets76835092vet_s
wekas123911792wekas
wets75940292wet_s
yeas78638422ye_as
yentas94614212yentas
yetis85418392yetis
yetts86715132yetts
zeta135121642zeta_

Search took 3 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.326548131.9
2DLD Change Limit538001401.72031279.1
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.09285416.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.