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

154 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
nuncio83797(None) 
nuncios937111nuncios
bunco94616082bunc_o
junco144612202junc_o
nuncle839362nuncle
unci65019462_unci_
uncia75015162_uncia
unco66021402_unc_o
alnico877943alnico
amnio75218053amn_io
ancho104515303_ancho
audio62917103au_dio
auntie64317703auntie
banco94019393banc_o
bucko134614023bu_cko
bunch125118603bunc_h
bunchy16437463bunchy
buncos104011593buncos
bunion83111313bun_ion
bunko115514513bun_ko
concho134414263concho
council1137473council
curio74221213cu_rio
danio6319783dan_io
duci76422623du_ci_
dunce86319263dunc_e
dunces95215753dunces
dunch115316263dunc_h
duncish1335793duncish
dunlin739723dunlin
fuci95720313fu_ci_
fugio9310923fu_gio
function1337843function
functor1235203functor
fundi96814913fundi_
fundic12389083fundic
fungi95014133fungi_
fungic12387813fungic
fungo94413133fun_go
funkia1336343funkia
guaco85012163guac_o
honcho14389383honcho
hunch136416213hunc_h
hunkie133812383hunkie
inunction1146893inunction
juco134716203ju_c_o
juncos15449233juncos
junction1736203junction
junior1386143jun_ior
junkie17339603junkie
junto125114563jun_to
lucid84314573lu_cid
lunch104917243lunc_h
lungi65516053lungi_
lungis77113023lungis
mucho125013443mu_cho
mucid104115253mu_cid
mucin93116823mu_cin
mucro94513723mu_cro
munch124917103munc_h
mungo84916053mun_go
muni65824413mun_i_
munis75022003mun_is
munnion935863munnion
muntin82915183muntin
muscid11219833muscid
nacho105414383n_acho
nance74721843nanc_e
nances83618643nances
nancies93516843nancies
nancy105214923nanc_y
nandin7313033nandin
nankin1039673nankin
nannie63713223nannie
narco76718243narc_o
niacin8310223niacin
nonacid101210843nonacid
nonce75719823nonc_e
nonces84418833nonces
noncom1039683noncom
nonego737013nonego
nuance859043nuanc_e
nuanced1036203nuanced
nuances938523nuances
nubbin10308293nubbin
nubia7311233nu_bia
nucha10229793nu_cha
nudie65118673nu_die
nudnick1452863nudnick
nudnik1153313nudnik
nun35537743nun___
nuncles939843nuncles
nunlike11258073nunlike
nunnish1035933nunnish
nuns45228233nun__s
nutria639913nutria
ounce77019933ounc_e
ounces83617773ounces
pencil103712973pencil
poncho133310123poncho
punch125118423punc_h
punchy16398523punchy
pundit92914183pundit
punji1438203punji_
punjis1536693punjis
punkie123513613punkie
punkin123611523punkin
punto75121323pun_to
rancho114310853rancho
rancid9513863rancid
runic73615773run_ic
senecio947203senecio
sulci7615053sulci_
sunlit61516103sunlit
tunic74018223tun_ic
tunica8379813tunica
tunics83811263tunics
unai44824783_unai_
unais53420773_unais
unbid83214643_unbid
uncap9312283_uncap
unchic1338643_unchic
unciae83215313_unciae
uncial83715223_uncial
uncini8310153_uncini
uncle7317053_uncle
unclip1046993_unclip
unclog956603_unclog
uncoil8811853_uncoil
uncool8610113_uncool
uncos74117033_uncos
uncoy104111413_uncoy
unction9310663_unction
uncus74014983_uncus
uncut73219173_uncut
undid72415363_undid
undo55620153_un_do
unfit84518563_unfit
unfix15429033_unfix
unhip10178823_unhip
union54519793_un_ion
unit45140073_un_it
unlit55025463_unlit
unmix14388973_unmix
unnail6410583unnail
unpin72613243_unpin
unrig61711413_unrig
unrip72012863_unrip
untie54425493_untie
until53517743_until
unto45824283_un_to
unwit84417523_unwit
unzip16207623_unzip
zincic1935903zincic

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.1261418182.5
2DLD Change Limit1127161545.62620034.8
3Display Results1541540.0463347.8
 (SQL Overall)1786911545.79830819.4
 
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.