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

150 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
anna4552901(None) 
ana39559831a_na
anga56831351anga
annal56520761annal
annas55824881annas
anoa45634471anoa
ansa45927771ansa
anta46839581anta
canna75919331canna
manna75522541manna
nana46632901nana
aa219179952a__a
aba512850952a_ba
abba810522652abba
acne66625872acne
acta69524802acta
aga410447232a_ga
agha87417302agha
agma77623262agma
aha611246642a_ha
ain37579092ain_
ains46158882ains
ala312463602a_la
alan46844082alan
alba68328332alba
alfa77624272alfa
alga57927602alga
alma66333022alma
ama510853302a_ma
amia66836902amia
amnia75918642amnia
an211879082a_n_
anal48037522anal
anas46649862anas
and47244172a_nd
ands57833612ands
ane37866952a_ne
anear55420322anear
anent54931842anent
anes45255932anes
anew76623132anew
angas65827982angas
angina7413132angina
ani37751182a_ni
anil46437432anil
anima74620072anima
anis45746462anis
ankh111114412ankh
anlas55626932anlas
annals66415922annals
anneal64812292anneal
annex12310882annex
annona648872annona
annoy869712annoy
annual64710702annual
annul55813382annul
anoas57226492anoas
anon46134852anon
ansae55720972ansae
ant37270792a_nt
antae56828292antae
antas55432032antas
ante46538902ante
anti45536362anti
antra56521922antra
ants47243472ants
anus47131112anus
any68440492a_ny
apnea73413412apnea
aqua132813962aqua
area45843392area
arena55323812arena
aria46245422aria
asana5315482asana
asea46327182asea
atma68121772atma
aunt46553652aunt
aura45836252aura
ava610139322a_va
awa611939672a_wa
awn68035912awn_
awns75324432awns
awny105919302awny
azan136521782azan
banana83213412banana
banda85223102banda
banns75321232banns
buna64730722buna
cannas84518402cannas
canny105817692canny
dona55529632dona
donna66215032donna
etna46415262etna
faena85014202faena
fanga96119622fanga
fanny114816042fanny
fauna84816512fauna
ganja131410002ganja
goanna736652goanna
hansa85416782hansa
henna84414042henna
inia45024702inia
inn36727432inn_
inns46920932inns
jnana12159042jnana
kana85928532kana
kina85631992kina
kuna85120702kuna
luna46229852luna
mana65341962mana
manana84816072manana
manga85026202manga
mania75634152mania
mannan85413622mannan
mannas85019802mannas
manta75629912manta
mina65136922mina
myna95815302myna
na28652482__na
naan47621932naan
nada58022902nada
nala46930392nala
nan37854882nan_
nanas55928632nanas
nanny84813812nanny
nans46139402nans
napa66927262napa
nona46929062nona
panda85022612panda
panga85323532panga
panne76623652panne
penna74520202penna
pina65842632pina
pinna75320182pinna
puna65331652puna
sanga66023792sanga
sauna54117552sauna
senna54617982senna
sunna55016062sunna
tanga64923692tanga
tanka93817482tanka
tuna45127842tuna
ulna46317322ulna
vanda94515922vanda
varna84516172varna
vena76126292vena
vina76331802vina
zanana153810362zanana
zanza1378702zanza
zona136321962zona

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298721500.92332364.0
3Display Results1501500.0305000.0
 (SQL Overall)1786911501.029173655.0
 
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.