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

152 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
anoas5722649(None) 
anas46649861an_as
angas65827981angas
anlas55626931anlas
annas55824881annas
anoa45634471anoa_
antas55432031antas
aas310975392a__as
abas68642082a_bas
abbas95918642abbas
abomas101113582abomas
abos67734412abo_s
ados57633512ado_s
aeons57624652aeons
agas55938842a_gas
aghas97014872aghas
agmas85919872agmas
agons66423782agons
agoras7613342agoras
alas46358122a_las
albas75925392albas
alfas87219042alfas
algas65624932algas
alias55834602alias
almas76629772almas
aloes54933672aloes
alohas9411702alohas
amas67746292a_mas
amias75831462amias
amoks11413552amoks
ana39559822an_a_
anabas8314082anabas
anal48037522an_al
ands57833612an_ds
anear55420322anear
anears63717182anears
anes45255932an_es
anga56831352anga_
angoras8811362angoras
anils56326722anils
animas84418722animas
anions64123032anions
anis45746462an_is
ankhs12116722ankhs
ankus91410682ankus
anna45529012anna_
annal56520762annal
annals66415922annals
annonas738792annonas
annoys967522annoys
anodal72512112anodal
anode65021032anode
anodes74418752anodes
anole55330372anole
anoles64827422anoles
anomy105113392anomy
anon46134852ano_n
anopias92412472anopias
anorak1038922anorak
anoraks1137602anoraks
anoxias14259102anoxias
ansa45927772ansa_
ansae55720972ansae
anta46839582anta_
antae56828292antae
antes56334322antes
antis55033312antis
ants47243472an_ts
anus47131112an_us
anyons94513502anyons
apneas83211382apneas
apnoeas946352apnoeas
apods86316342apods
apos65433822apo_s
aquas142412612aquas
areas55935772areas
arias55438022arias
aromas81018612aromas
arras55626132arras
atlas55821582atlas
atmas75721012atmas
atoms76817562atoms
auras55932552auras
avgas96912132avgas
avos77227012avo_s
avows114910982avows
awols84713522awols
axons125517932axons
azons146518252azons
bandas95120542bandas
boas66150832_boas
cannas84518402cannas
canoes84725882canoes
canolas9313992canolas
canons85522062canons
canvas113813332canvas
donas65926472donas
enols54718402enols
enows85115492enows
fangas105017192fangas
fanons96115212fanons
fanos85926502fano_s
ganjas14149112ganjas
ganofs104010292ganofs
genoas74013622genoas
goas55239942_goas
hansas94616042hansas
kanas95326912kan_as
knobs11519712knobs
knops115911812knops
knots95614722knots
knows124912412knows
koas85635092_koas
manas76240422man_as
mangas94122922mangas
manias84029032manias
mannas85019802mannas
manors84420882manors
manos74933612mano_s
mantas85725362mantas
moas65545342_moas
monas74732152monas
nadas66320812nadas
nalas55528362nalas
nanas55928632nanas
naos47429732nao_s
napas75924352napas
nobs66436902_nobs
nods55838222_nods
noes45845392_noes
nogs56534612_nogs
nomas74726412_nomas
noms65636402_noms
nonas55126652_nonas
nos38859322_no_s
nous46136982_nous
novas85215362_novas
nows75738232_nows
onos46229002ono_s
pandas95521962pandas
pangas99921102pangas
proas75028802proas
psoas75012982psoas
sangas75222652sangas
snobs74716152snobs
snogs66017492snogs
snots55225102snots
snows84719882snows
stoas55126022stoas
tankas104613762tankas
vandas103915992vandas
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.0931921408.6
2DLD Change Limit538001521.95327547.4
3Display Results1521520.0463304.3
 (SQL Overall)1786911522.09285416.3
 
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.