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

191 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
lunas5502501(None) 
bunas75126571bunas
lumas75622911lumas
luna46229851luna_
lunar57017311lunar
lunars65012811lunars
lunes55337771lunes
lungs65223881lungs
lunks94822451lunks
lunts55826901lunts
punas74826751punas
tunas54224121tunas
ulnas55716531ulnas
anas46649862_anas
annas55824882annas
aunts55227632aunts
auras55932552auras
blunts84512892blunts
buna64730722buna_
bunds85523542bunds
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
bunyas11359432bunyas
buras74736292buras
clunks124811012clunks
cunts76125122cunts
donas65926472donas
dumas85420432dumas
dunam8313732dunam
dunams937832dunams
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunts65828412dunts
duras65727722duras
etnas54713932etnas
faunas94013632faunas
flunks13469862flunks
funds94119252funds
funks125318912funks
funs75235732fun_s
guans64419442guans
gunks104517722gunks
guns55533482gun_s
hulas84920882hulas
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
jubas144614222jubas
judas134911882judas
junks164815972junks
juntas134210502juntas
kanas95326912kanas
kinas95626912kinas
kuna85120702kuna_
lacunas9138172lacunas
lagunas8156822lagunas
lamas75532792lamas
lanai5319572lanai
lanais6316792lanais
lands65426902lands
lanes54946792lanes
las37281472l__as
lauans65113532lauans
lauras63414332lauras
lavas85422222lavas
leans55536252leans
leas45954182l_eas
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
lianas63713382lianas
limas75627632limas
linac7315412linac
linacs8310812linacs
lines57054572lines
lingas75116562lingas
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
liras56021982liras
litas54923772litas
loans56026462loans
longs65527062longs
lotas55926302lotas
loumas84812332loumas
luau44824162lu_au
luaus54514902luaus
lubes74727992lubes
luces75528432luces
lucks115723562lucks
ludes65728852ludes
lues45943552lu_es
luffas12337482luffas
luffs114516282luffs
luges65928752luges
lugs55233522lu_gs
lulls54119652lulls
lulus54315162lulus
luma65527522luma_
lumps95624982lumps
lums65734242lu_ms
lunacy1136842lunacy
lunate6316042lunate
lunch104917242lunch
lune47140492lun_e
lunet56835422lunet
lunets66914762lunets
lung55732492lun_g
lungan74710212lungan
lungans8399052lungans
lunge65323802lunge
lunges76123422lunges
lungi65516052lungi
lungis77113022lungis
lunies64723012lunies
lunk86030722lun_k
lunt46148842lun_t
luny77324132lun_y
lupus74512522lupus
lures56138532lures
lurks95218742lurks
lusts55022802lusts
lusus54813872lusus
lutes55836662lutes
luvs75818502lu_vs
luxes124921502luxes
manas76240422manas
minas75434112minas
monas74732152monas
munis75022002munis
muns65535912mun_s
muras75329562muras
mynas105815232mynas
nanas55928632nanas
nonas55126652nonas
nuns45228232nun_s
pinas75434452pinas
plunks124711162plunks
pujas145513322pujas
pumas95121562pumas
puna65331652puna_
pungs85422222pungs
punkas123410672punkas
punks114822682punks
puns66641482pun_s
punts75828002punts
pupas95219282pupas
ruanas6311262ruanas
runes55530222runes
rungs611819402rungs
runs46438072run_s
runts55927632runts
saunas63915432saunas
subas74724072subas
sunnas63914562sunnas
sunns55017352sunns
suns45841902sun_s
suras55336322suras
tubas75119572tubas
tufas85314382tufas
tuna45127842tuna_
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
ulans54921302ulans
ulna46317322ulna_
ulnad65611452ulnad
ulnae55214572ulnae
ulnar56013982ulnar
ulvas84511502ulvas
unai44824782_unai
unais53420772_unais
unau43924152_unau
unaus53216572_unaus
uns35936752_un_s
upas68322382_upas
utas45924952_utas
vinas85126342vinas
yuans84613322yuans
yucas106013912yucas
yugas95012062yugas

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.1701051123.5
2DLD Change Limit538001911.73630990.8
3Display Results1911910.0762513.2
 (SQL Overall)1786911911.98290156.9
 
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.