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

134 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
annas5582488(None) 
anas46649861a_nas
angas65827991angas
anlas55626931anlas
anna45529011anna_
annal56520761annal
annals66415921annals
anoas57226491anoas
antas55432031antas
cannas84518401cannas
mannas85019801mannas
nanas55928631nanas
aas310975392a__as
abas68642082a_bas
abbas95918642abbas
acnes75922622acnes
agas55938842a_gas
aghas97014872aghas
agmas85919872agmas
ains46158882ain_s
alans55636172alans
alas46358122a_las
albas75925392albas
alfas87219042alfas
algas65624932algas
alias55834602alias
almas76629772almas
amas67746292a_mas
amias75831472amias
ana39559832a_na_
anabas8314082anabas
anal48037522a_nal
ands57833612a_nds
anear55420322anear
anears63717182anears
anes45255932a_nes
anga56831362anga_
anginas8310952anginas
anils56326722anils
animas84418722animas
anis45746462a_nis
ankhs12116722ankhs
ankus91410682ankus
annates72415422annates
anneal64812302anneal
anneals7449952anneals
annex12310882annex
annonas738792annonas
annoy869712annoy
annoys967522annoys
annual64710702annual
annuals7388192annuals
annul55813382annul
annuls64711732annuls
anoa45634472anoa_
ansa45927772ansa_
ansae55720972ansae
anta46839582anta_
antae56828292antae
antes56334322antes
antis55033312antis
ants47243472a_nts
anus47131112a_nus
apneas83211382apneas
aquas142412612aquas
areas55935772areas
arenas65021992arenas
arias55438022arias
arras55626132arras
asanas6514112asanas
atlas55821582atlas
atmas75721012atmas
aunts55227632aunts
auras55932562auras
avgas96912132avgas
awns75324432awn_s
azans146516882azans
bananas93312222bananas
bandas95120542bandas
banns75321232bann_s
bunas75126572bunas
canna75919332canna_
canvas113813332canvas
donas65926472donas
donnas75511322donnas
etnas54713932etnas
faenas94412762faenas
fangas105017202fangas
faunas94013632faunas
ganjas14149112ganjas
goannas836222goannas
hansas94616042hansas
hennas94211802hennas
inns46920932inn_s
jnanas13207302jnanas
kanas95326912kanas
kinas95626912kinas
lunas55025012lunas
mananas93414732mananas
manas76240432manas
mangas94122932mangas
manias84029032manias
manna75522542manna_
mannan85413622mannan
mannans93611522mannans
mantas85725362mantas
minas75434112minas
monas74732152monas
mynas105815232mynas
naans55815252naans
nadas66320812nadas
nalas55528362nalas
nana46632902nana_
nans46139402nan_s
napas75924352napas
nonas55126652nonas
pandas95521962pandas
pangas99921112pangas
pannes85522852pannes
pinas75434452pinas
pinnas85315512pinnas
punas74826752punas
sangas75222662sangas
saunas63915432saunas
sennas64214232sennas
sunnas63914562sunnas
tankas104613772tankas
tunas54224122tunas
ulnas55716532ulnas
vandas103915992vandas
varnas94212822varnas
vinas85126342vinas
zananas16319562zananas
zanzas1487052zanzas

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.293609866.9
2DLD Change Limit538001341.75330690.2
3Display Results1341340.0304466.7
 (SQL Overall)1786911342.07686074.7
 
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.