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

248 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
kanas9532691(None) 
anas46649861_anas
kaas86531841ka_as
kakas85117341kakas
kana85928521kana_
kanes95529371kanes
kapas116021731kapas
katas95922091katas
kavas125919951kavas
kinas95626911kinas
manas76240421manas
nanas55928631nanas
aas310975392_a_as
abas68642082_abas
agas55938842_agas
alas46358122_alas
amas67746292_amas
ana39559822_ana_
anal48037522_anal
ands57833612_ands
anes45255932_anes
angas65827982_angas
anis45746462_anis
anlas55626932_anlas
annas55824882annas
anoas57226492_anoas
ansa45927772_ansa
antas55432032_antas
ants47243472_ants
anus47131112_anus
asanas6514112asanas
baas66844672ba_as
babas96325732babas
balas76937212balas
banal75925992banal
bandas95120542bandas
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ban_s
bunas75126572bunas
bwanas1157442bwanas
cacas95627982cacas
camas96333522camas
canal75428042canal
canals84421662canals
canes75350372canes
cannas84518402cannas
cans65050842can_s
cants77036942cants
canvas113813332canvas
casas75327842casas
dadas75819862dadas
dangs75623202dangs
dans56748142dan_s
donas65926472donas
etnas54713932etnas
faenas94412762faenas
fanes84639892fanes
fangas105017192fangas
fangs96224072fangs
fanos85926502fanos
fans76247362fan_s
faunas94013632faunas
favas115618592favas
galas65731642galas
gamas85431352gamas
gangs76222572gangs
ganjas14149112ganjas
hahas117118442hahas
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hansa85416782hansa
hansas94616042hansas
hants86335402hants
janes124928122janes
javas155915422javas
jnanas13207302jnanas
kabab134814432kabab
kababs14409762kababs
kabar114815552kabar
kabars124513952kabars
kabs107130842ka_bs
kadis105921062kadis
kaes85734062ka_es
kafs116423742ka_fs
kagus105812032kagus
kahunas1473952kahunas
kaiak8310352kaiak
kaiaks937042kaiaks
kaifs125715642kaifs
kails95525212kails
kains96125642kains
kaka76518682kaka_
kakis86116842kakis
kalam11315112kalam
kalams12310602kalams
kales95730982kales
kalpas124112942kalpas
kames115024692kames
kanaka9357522kanaka
kanakas10327212kanakas
kanban1238622kanban
kanbans1337722kanbans
kane85133962kan_e
kanji1647452kanji
kanjis1735962kanjis
kantar10311152kantar
kantars11310032kantars
kanzu1847592kanzu
kanzus1944602kanzus
kaons95014852kaons
kapa106021292kapa_
kaphs144911502kaphs
kappas144410362kappas
karat96837592karat
karats106420492karats
karmas123013732karmas
karns96624142karns
karts97630112karts
kas77058582k__as
kashas133311902kashas
kata85626022kata_
kats85944332ka_ts
kava115819702kava_
kavass13517302kavass
kayak1138362kayak
kayaks1236332kayaks
kayos127714702kayos
kays116032192ka_ys
keas86337092k_eas
kenaf12316032kenaf
kenafs1337112kenafs
kenos95220622kenos
kens85435232ken_s
khans124615172khan_s
kiangs11378362kiangs
kina85631992kina_
kinase104210652kinase
kinds106221812kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
kivas124614732kivas
knap105815402k_nap
knaps115511172knaps
knar85818722k_nar
knars94416112knars
koalas104011662koalas
koans95818622koan_s
koas85635092k_oas
kolas94822232kolas
konks84917112konks
koras95927112koras
kuna85120702kuna_
kvas117015942k_vas
kwanzas2342052kwanzas
lamas75532792lamas
lanai5319572lanai
lanais6316792lanais
lands65426902lands
lanes54946792lanes
lavas85422222lavas
lianas63713382lianas
lunas55025012lunas
mamas95930772mamas
mana65341942mana_
manat76039982manat
manats84623462manats
manes76648952manes
mangas94122922mangas
manias84029032manias
mannas85019802mannas
manos74933612manos
mans66354532man_s
mantas85725362mantas
manus75924922manus
maras75443282maras
masas75630412masas
mayas105924382mayas
minas75434112minas
monas74732152monas
mynas105815232mynas
naans55815252naans
nadas66320812nadas
nalas55528362nalas
nana46632892nana_
nans46139392nan_s
napas75924352napas
nonas55126652nonas
pacas96029402pacas
pandas95521962pandas
panes76148692panes
pangas99921102pangas
pangs84628662pangs
pans65855722pan_s
pants76536922pants
papas94927492papas
paras76143042paras
pinas75434452pinas
punas74826752punas
qanat144426842qanat
qanats154112812qanats
ragas65326062ragas
raias54631122raias
rajas127317722rajas
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rants55935342rants
rayas85922052rayas
ruanas6311262ruanas
sagas66025882sagas
sands65228582sands
sanes55649072sanes
sangas75222652sangas
sans45153352san_s
saunas63915432saunas
skanks94710832skanks
takas95520682takas
talas55935892talas
tangs65028342tangs
tankas104613762tankas
tanks94624732tanks
tans46154812tan_s
tapas74627712tapas
tunas54224122tunas
ulnas55716532ulnas
vandas103915992vandas
vanes85130972vanes
vangs96319582vangs
vans76236722van_s
varas86028192varas
varnas94212822varnas
vinas85126342vinas
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452262wan_s
wants87932212wants
yangs95618692yangs
yanks125316572yanks
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 Limit538002481.86028924.7
3Display Results2482480.0763263.2
 (SQL Overall)1786912482.02988068.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.