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
kanas9532692(None) 
anas46649861_anas
kaas86531861ka_as
kakas85117351kakas
kana85928551kana_
kanes95529371kanes
kapas116021741kapas
katas95922101katas
kavas125919961kavas
kinas95626921kinas
manas76240431manas
nanas55928631nanas
aas310975392_a_as
abas68642082_abas
agas55938842_agas
alas46358122_alas
amas67746302_amas
ana39559832_ana_
anal48037522_anal
ands57833622_ands
anes45255932_anes
angas65827992_angas
anis45746472_anis
anlas55626932_anlas
annas55824882annas
anoas57226492_anoas
ansa45927772_ansa
antas55432032_antas
ants47243472_ants
anus47131112_anus
asanas6514112asanas
baas66844672ba_as
babas96325732babas
balas76937212balas
banal75925992banal
bandas95120542bandas
bands85233432bands
banes74945582banes
bangs85627782bangs
banks115527902banks
banns75321232banns
bans66555142ban_s
bunas75126572bunas
bwanas1157442bwanas
cacas95627982cacas
camas96333532camas
canal75428042canal
canals84421672canals
canes75350372canes
cannas84518402cannas
cans65050852can_s
cants77036942cants
canvas113813332canvas
casas75327842casas
dadas75819862dadas
dangs75623212dangs
dans56748152dan_s
donas65926472donas
etnas54713932etnas
faenas94412762faenas
fanes84639892fanes
fangas105017202fangas
fangs96224082fangs
fanos85926502fanos
fans76247372fan_s
faunas94013632faunas
favas115618592favas
galas65731642galas
gamas85431372gamas
gangs76222582gangs
ganjas14149112ganjas
hahas117118442hahas
hands95327382hands
hangs95726732hangs
hanks126226862hanks
hansa85416782hansa
hansas94616042hansas
hants86335402hants
janes124928122janes
javas155915422javas
jnanas13207302jnanas
kabab134814452kabab
kababs14409772kababs
kabar114815562kabar
kabars124513952kabars
kabs107130852ka_bs
kadis105921072kadis
kaes85734072ka_es
kafs116423752ka_fs
kagus105812032kagus
kahunas1473952kahunas
kaiak8310372kaiak
kaiaks937042kaiaks
kaifs125715652kaifs
kails95525222kails
kains96125652kains
kaka76518702kaka_
kakis86116842kakis
kalam11315122kalam
kalams12310612kalams
kales95730982kales
kalpas124112952kalpas
kames115024702kames
kanaka9357522kanaka
kanakas10327212kanakas
kanban1238632kanban
kanbans1337722kanbans
kane85133982kan_e
kanji1647452kanji
kanjis1735962kanjis
kantar10311162kantar
kantars11310032kantars
kanzu1847592kanzu
kanzus1944602kanzus
kaons95014852kaons
kapa106021312kapa_
kaphs144911502kaphs
kappas144410372kappas
karat96837612karat
karats106420502karats
karmas123013762karmas
karns96624152karns
karts97630122karts
kas77058592k__as
kashas133311912kashas
kata85626042kata_
kats85944342ka_ts
kava115819722kava_
kavass13517302kavass
kayak1138372kayak
kayaks1236332kayaks
kayos127714702kayos
kays116032202ka_ys
keas86337102k_eas
kenaf12316032kenaf
kenafs1337112kenafs
kenos95220622kenos
kens85435252ken_s
khans124615172khan_s
kiangs11378362kiangs
kina85632012kina_
kinase104210652kinase
kinds106221832kinds
kines95039142kines
kings105825572kings
kinks84926092kinks
kinos96626152kinos
kins85747922kin_s
kivas124614742kivas
knap105815412k_nap
knaps115511172knaps
knar85818732k_nar
knars94416112knars
koalas104011662koalas
koans95818622koan_s
koas85635102k_oas
kolas94822232kolas
konks84917112konks
koras95927122koras
kuna85120712kuna_
kvas117015952k_vas
kwanzas2342052kwanzas
lamas75532802lamas
lanai5319572lanai
lanais6316792lanais
lands65426902lands
lanes54946792lanes
lavas85422222lavas
lianas63713382lianas
lunas55025012lunas
mamas95930782mamas
mana65341962mana_
manat76039992manat
manats84623462manats
manes76648962manes
mangas94122932mangas
manias84029032manias
mannas85019802mannas
manos74933622manos
mans66354552man_s
mantas85725362mantas
manus75924932manus
maras75443302maras
masas75630412masas
mayas105924382mayas
minas75434112minas
monas74732152monas
mynas105815232mynas
naans55815252naans
nadas66320812nadas
nalas55528362nalas
nana46632902nana_
nans46139402nan_s
napas75924352napas
nonas55126652nonas
pacas96029402pacas
pandas95521962pandas
panes76148692panes
pangas99921112pangas
pangs84628672pangs
pans65855732pan_s
pants76536922pants
papas94927492papas
paras76143052paras
pinas75434452pinas
punas74826752punas
qanat144426842qanat
qanats154112812qanats
ragas65326062ragas
raias54631122raias
rajas127317722rajas
rands65930452rands
ranis55235842ranis
ranks95225732ranks
rants55935342rants
rayas85922052rayas
ruanas6311262ruanas
sagas66025882sagas
sands65228582sands
sanes55649072sanes
sangas75222662sangas
sans45153362san_s
saunas63915432saunas
skanks94710832skanks
takas95520682takas
talas55935892talas
tangs65028362tangs
tankas104613772tankas
tanks94624742tanks
tans46154832tan_s
tapas74627712tapas
tunas54224122tunas
ulnas55716532ulnas
vandas103915992vandas
vanes85130982vanes
vangs96319602vangs
vans76236742van_s
varas86028202varas
varnas94212832varnas
vinas85126342vinas
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452272wan_s
wants87932212wants
yangs95618702yangs
yanks125316572yanks
zanzas1487052zanzas

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 Filter178691538000.330541487.9
2DLD Change Limit538002481.54634799.5
3Display Results2482480.0604133.3
 (SQL Overall)1786912481.93692299.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.