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 “tunica” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

262 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
tunica837981(None) 
tunic74018221tunic_
tunicae9328141tunicae
tunics83811261tunics
arnica8310442arnica
runic73615772runic_
tenia55324482teni_a
tonic74727652tonic_
tonics83617862tonics
tuna45127842tun__a
tundra736422tundra
tunicate103310042tunicate
tunicle9308032tunicle
tuning74016842tuning
uncia75015162_uncia
alnico877943alnico
amnia75918643amni_a
amnic95516243amnic_
anima74620073_anima
arnicas939543arnicas
atonia63816513atoni_a
atonic83420473atonic_
atonics93613713atonics
aulic74420243aulic_
auric74521733auric_
bonita8312943bonita
botanica1295723botanica
buna64730723bun__a
bunch125118603bun_ch
bunco94616083bun_co
bunion83111313bunion
bunya103810093bun_ya
chica125818263_chica
cnida878953_cnida
conic95329793conic_
conical11316203conical
conics103920593conics
cubic114313423cubic_
cubical1338463cubical
cubics123810163cubics
curia74523773curi_a
cynic124712423cynic_
cynical1437873cynical
cynics13377363cynics
dulia61014983duli_a
dunce86319263dun_ce
dunch115316263dun_ch
duncical1345213duncical
dunite7315013dunite
erica7316543_erica
ethnic1148853ethnic_
ethnical1346363ethnical
ethnics1236263ethnics
eunuch1154363eunuch
finca104714503fin_ca
finical1239693finical
fundic12389083fundic_
fungic12387813fungic_
funicle12237483funicle
funkia1336343funkia
genic85119393genic_
gonia64117533goni_a
guaiac946153guaiac
guinea737613guinea
gunite7414403gunite
haniwa1236743haniwa
huic94818053hu_ic_
humic124113243humic_
hunch136416213hun_ch
inia45024703_ini_a
ionic74622663ionic_
ionics84214483ionics
juice14311323ju_ice
juicy1738283ju_icy
junco144612203jun_co
junior1386143junior
junta123713673jun_ta
kuna85120703kun__a
lexica1536103lexica
lorica8310443lorica
ludic82912803ludic_
lumina84613543lumina
luna46229853lun__a
lunacy1136843lunacy
lunch104917243lun_ch
lunier64617603lunier
lunies64723013lunies
lunula636173lunula
mania75634153mani_a
maniac103917973maniac
manic94629443manic_
manics103919933manics
manila84518303manila
manioca11358943manioca
mica86428253__mica
minicab13177163minicab
minicam131110053minicam
minicar11109313minicar
minima105512653minima
modica11310063modica
munch124917103mun_ch
muni65824413muni__
munis75022003muni_s
muonic10410183muonic_
musca9311763mu_sca
music94316403music_
musical1139553musical
musick14408703musick
musics103911783musics
myrica1336833myrica
nicad8312613__nicad
nice65534713__nice
nick106627603__nick
nipa69421633__nipa
nubia7311233nubi_a
nudnick1452863nudnick
numina83510843numina
nuncio837973nuncio
ounce77019933oun_ce
panic93923903panic_
panics103815363panics
petunia966803petuni_a
pica85831493__pica
plica9613373_plica
pubic114513723pubic_
pudic104614563pudic_
pumice1238223pumice
puna65331653pun__a
punch125118423pun_ch
punier84519223punier
punily11311773punily
punish111411503punish
punka114515483pun_ka
quaich2047693quaich
quick204311063qu_ick
quince173910133quince
quinic17319473quinic_
quinina16278143quinina
quinoa15377653quinoa
quinta153312373quinta
rumina83412483rumina
seneca839793seneca
silica8311243silica
snick114416013_snick
sonic75225293sonic_
sonics84315633sonics
spica94717943_spica
sunna55016063sun_na
taenia6313193taeni_a
tafia84215493tafi_a
taiga64115663t_aiga
tanga64923693tan_ga
tanist6324593tanist
tanka93817483tan_ka
tannic82811473tannic_
tantra63713353tantra
tapioca1144633tapioca
taxicab1843413taxicab
telia55821143teli_a
telic76019823telic_
tenace82715693tenace
tench105620003ten_ch
teniae64517353teniae
tenias64720073tenias
theca103311453t_heca
thick145613353t_hick
thrice114311573thrice
thulia936113thuli_a
tibia7312403tibi_a
tic56343463t__ic_
tical76021493t__ical
tick106231223t__ick
tics65729633t__ics
tincal83913363tin_cal
tinct76126233tin_ct
tinea54923163tin_ea
tinier63622233tinier
tinily94014433tinily
tining74927543tining
tonga65619693ton_ga
tonier65520713tonier
toning74025793toning
tonish93415903tonish
topic95721503topic_
topical1139953topical
topics104714583topics
toric76529313toric_
torics85118353torics
toxic145315623toxic_
toxical1637643toxical
toxics153910203toxics
triac74116373t_riac
trice75127493t_rice
trick115420693t_rick
troika1035493troika
tuba65422363tu__ba
tubing93813093tubing
tubist83013163tubist
tuck104626573tu__ck
tufa75016613tu__fa
tui37034023tu_i__
tuis44829643tu_i_s
tulip71111693tuli_p
tulips8137253tulips
tumid84114023tumi_d
tun35845193tun___
tunas54224123tun_as
tundish1137283tundish
tundras857113tundras
tune45635863tun__e
tuned64622313tun_ed
tuner56022683tun_er
tuners64417343tuners
tunes55332193tun_es
tuneup835203tuneup
tung55328163tun__g
tungs65520623tun_gs
tunicated12257493tunicated
tunicates11268743tunicates
tunicles10217133tunicles
tunned74014493tunned
tunnel64310633tunnel
tunnies73614263tunnies
tunning83514453tunning
tunny86515033tun_ny
tuns45138663tun__s
tupik1149003tupi_k
tupiks1235493tupiks
turaco839453turaco
turion6313163turion
turista737443turista
turning83713183turning
turnip836593turni_p
turnips935013turnips
turrical1046203turrical
twice104711123t_wice
tyning105510413tyning
typic124511963typic_
typical1436343typical
umiac938963_umiac
uncap9312283_un_cap
unci65019463_un_ci
unciae83215313_unciae
uncial83715223_uncial
unco66021403_un_co
unify113611113_unify
union54519793_union
unit45140073_uni_t
unite54828383_unite
units54923433_units
unity84918493_unity
unpick1446903_unpick
uric63624933_uric_
vesica11157913vesica
vinca105315163vin_ca
vinic10314973vinic_
vomica1336383vomica
xenia124814773xeni_a
xenic144114643xenic_
yonic105920843yonic_
yuca95716723yu__ca
yucca12467443yu_cca

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162625.44020719.9
3Display Results2622620.0932817.2
 (SQL Overall)1786912625.67331498.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.