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

179 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
tunas5422412(None) 
bunas75126571bunas
lunas55025011lunas
punas74826751punas
tubas75119581tubas
tufas85314381tufas
tuna45127841tuna_
tunes55332191tunes
tungs65520631tungs
tuns45138661tun_s
anas46649862_anas
annas55824882annas
aunts55227632aunts
auras55932562auras
buna64730722buna_
bunds85523542bunds
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
bunyas11359432bunyas
buras74736302buras
cunts76125122cunts
donas65926472donas
dumas85420432dumas
dunam8313732dunam
dunams937832dunams
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunts65828412dunts
duras65727732duras
etnas54713932etnas
faunas94013632faunas
funds94119252funds
funks125318912funks
funs75235732fun_s
guans64419442guans
gunks104517722gunks
guns55533482gun_s
hulas84920882hulas
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
jubas144614222jubas
judas134911882judas
junks164815972junks
juntas134210502juntas
kanas95326922kanas
kinas95626922kinas
kuna85120712kuna_
lumas75622912lumas
luna46229852luna_
lunar57017312lunar
lunars65012812lunars
lunes55337772lunes
lungs65223882lungs
lunks94822452lunks
lunts55826902lunts
manas76240432manas
minas75434112minas
monas74732152monas
munis75022002munis
muns65535922mun_s
muras75329582muras
mynas105815232mynas
nanas55928632nanas
nonas55126652nonas
nuns45228232nun_s
pinas75434452pinas
pujas145513322pujas
pumas95121562pumas
puna65331652puna_
pungs85422222pungs
punkas123410672punkas
punks114822682punks
puns66641482pun_s
punts75828002punts
pupas95219282pupas
ruanas6311262ruanas
runes55530222runes
rungs611819402rungs
runs46438082run_s
runts55927632runts
saunas63915432saunas
stuns54719492stun_s
stunts65615252stunts
stupas83910882stupas
subas74724082subas
sunnas63914562sunnas
sunns55017352sunns
suns45841902sun_s
suras55336332suras
takas95520682takas
talas55935892talas
tangs65028362tangs
tankas104613772tankas
tanks94624742tanks
tans46154832tan_s
tapas74627712tapas
tas38477102t__as
taunts65715662taunts
teas45851492t_eas
tends65425582tends
tenias64720072tenias
tens45647412ten_s
tents56434212tents
tepas76521682tepas
texas126514932texas
thujas1634432thujas
thunks13459032thunks
thuyas1234772thuyas
tineas64616482tineas
tines54848422tines
tings65329212tings
tins45251312tin_s
tints56030922tints
toeas55726422toeas
togas67823002togas
tolas54532772tolas
tonal53724302tonal
tones56048662tones
tongas74315532tongas
tongs65928472tongs
tons46553052ton_s
tonus56324302tonus
toras55540372toras
trans54933042trans
tronas63816902tronas
trunks10429752trunks
tuba65422362tuba_
tubae74716642tubae
tubal75517202tubal
tubes74826452tubes
tubs65430062tu_bs
tucks114721122tucks
tufa75016612tufa_
tuffs115118262tuffs
tufts85713272tufts
tugs56231672tu_gs
tuis44829642tu_is
tules54532792tules
tumps95420792tumps
tun35845192tun__
tundras857112tundras
tune45635862tun_e
tuned64622312tuned
tuner56022682tuner
tuners64417342tuners
tung55328172tun_g
tunic74018222tunic
tunics83811262tunics
tunny86515032tunny
tups65628762tu_ps
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
tusks94915532tusks
tuts45838452tu_ts
tutus55214812tutus
tuxes124316042tuxes
twas76824082t_was
tynes85920302tynes
ulnas55716532ulnas
unai44824782_unai
unais53420772_unais
unau43924152_unau
unaus53216572_unaus
uns35936762_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.313570897.8
2DLD Change Limit538001791.70331591.3
3Display Results1791790.0463891.3
 (SQL Overall)1786911792.06286659.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.