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

177 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
anoa4563447(None) 
ana39559821an_a
anga56831351anga
anna45529011anna
anoas57226491anoas
anon46134851anon
ansa45927771ansa
anta46839581anta
aa219179952a__a
aba512850952a_ba
abba810522642abba
abo59045962abo_
aboma91114602aboma
abos67734412abos
acta69524802acta
ado49146872ado_
ados57633512ados
aeon45634612aeon
aga410447232a_ga
agha87417302agha
agma77623262agma
ago48845522ago_
agog68019002agog
agon56531882agon
agora6914332agora
aha611246642a_ha
ahoy101919182ahoy
ala312463602a_la
alba68328332alba
alfa77624272alfa
alga57927602alga
alma66333022alma
aloe45540192aloe
aloha8513612aloha
alow75328592alow
ama510853302a_ma
amia66836892amia
amnia75918632amnia
amok10217402amok
an211879072an__
anal48037522anal
anas46649862anas
ancon75718232ancon
and47244162an_d
ands57833612ands
ane37866942an_e
anear55420322anear
anes45255932anes
anew76623132anew
angas65827982angas
angora71111572angora
ani37751172an_i
anil46437432anil
anima74620072anima
anion55028812anion
anis45746462anis
ankh111114412ankh
anlas55626932anlas
annal56520762annal
annas55824882annas
annona648872annona
annoy869712annoy
anodal72512112anodal
anode65021032anode
anole55330372anole
anomy105113392anomy
anopia83412392anopia
anorak1038922anorak
anoxia133510022anoxia
ansae55720972ansae
ant37270782an_t
antae56828292antae
antas55432032antas
ante46538902ante
anti45536362anti
antra56521922antra
ants47243472ants
anus47131112anus
any68440482an_y
anyon85615222anyon
apnea73413412apnea
apnoea867092apnoea
apo511142122apo_
apod78123182apod
apos65433822apos
aqua132813962aqua
area45843392area
aria46245422aria
aroma71220142aroma
asea46327182asea
atma68121772atma
atom67824522atom
atop66124752atop
aura45836252aura
ava610139322a_va
avo68936232avo_
avos77227012avos
avow107816462avow
awa611939672a_wa
awol75620672awol
axon115524302axon
azo128233392azo_
azon135725052azon
banda85223102banda
boa56954032_boa
canna75919332canna
canoe75627252canoe
canola8313622canola
canon74725302canon
dona55529632dona
enol45823822enol
enow77819872enow
fanga96119622fanga
fano75831682fano_
fanon84619012fanon
fanos85926502fanos
ganja131410002ganja
ganof95420362ganof
genoa64315822genoa
goa47343802_goa
hansa85416782hansa
inia45024692inia
kana85928522kan_a
knob107417012knob
knop107116592knop
knot85630502knot
know116115842know
koa76737772_koa
mana65341942man_a
manga85026192manga
mania75634142mania
manna75522532manna
mano66536792mano_
manor78023922manor
manos74933612manos
manta75629902manta
moa57249182_moa
na28652482_n_a
nada58022902nada
nala46930392nala
nana46632892nana
naoi46024632naoi
naos47429732naos
napa66927262napa
no29353242_no_
nob58954422_nob
nod47549562_nod
nog46847312_nog
noh66640642_noh
nom510450642_nom
noma67529462_noma
nona46929062_nona
noo37154042_noo
nor38048822_nor
nos38859322_nos
not39474662_not
nota46830772_nota
nova76518952_nova
now65950192_now
ono36838032ono_
onos46229002onos
panda85022612panda
panga85323532panga
proa66229962proa
sanga66023792sanga
snob65825592snob
snog55623632snog
snot44745442snot
snow76324792snow
stoa45425912stoa
tanga64923682tanga
tanka93817482tanka
vanda94515922vanda
whoa106615202whoa
zanza1378702zanza
zoa128529992_zoa
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.0802233637.5
2DLD Change Limit298721771.03029001.9
3Display Results1771770.0305900.0
 (SQL Overall)1786911771.140156746.5
 
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.