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

220 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
unnails73822(None) 
unnail6410581unnail_
agnails837002agnails
annals66415922anna_ls
entails7912822entails
nails55730402__nails
renails74917262renails
snails64816652_snails
tenails73713922tenails
unais53420772u_nai_s
uncials92510522uncials
uncoils979532uncoils
unhairs1036372unhairs
unnailed9229442unnailed
unsnarls894882unsnarls
unveils1045752unveils
agnail739533agnail_
ails45654713___ails
anils56326723_an_ils
annal56520763anna_l_
annalist8413753annalist
annas55824883anna__s
annates72415423annates
anneals7449943anneals
annuals7388193annuals
annuls64711733ann_uls
anvils9219713_anvils
assails769093assails
avails939693_avails
bails75933523__bails
bewails1277553bewails
brails84621293_brails
bunnies94415003bunn_ies
camails11311753camails
canals84421663cana_ls
curtails10318243curtails
denials84114133denials
dentils84115583dentils
derails84216393derails
details84214043details
drails74716953_drails
dunnages10154933dunnages
emails84412343_emails
engrails945383engrails
ennuis636473ennui_s
ensnarls873393ensnarls
entail61114343entail_
entoils7810733entoils
entrails8310163entrails
fails85631483__fails
fantails1139693fantails
finalis103313663finalis
finals94316163fina_ls
finials103210153finials
flails94313003_flails
frails93716473_frails
funfairs1442133funfairs
fungals11276783funga_ls
funnels10348173funn_els
funnies104113603funn_ies
funnily1336373funn_ily
gnarls74210773_gnarls
grails77518783_grails
gunnels8358563gunn_els
gunnies83413123gunn_ies
hails85231643__hails
hangnails1353003hangnails
hobnails1343303hobnails
infalls1038943infalls
inhauls1035523inhauls
innages82911303innages
innards837153innards
instils7811453instils
inwalls1037283inwalls
jails125422943__jails
jezails2334163jezails
kails95525213__kails
lanais6316793lanai_s
lentils73912973lentils
lugsails942743lugsails
mails76037783__mails
menials94015683menials
naifs87617423__naifs
nail45838653__nail_
nihils937573_nihils
nils46132453__n_ils
noils55024333__noils
nuncios937113nuncios
outsails8139863outsails
oxtails1436383oxtails
pails75833063__pails
pencils113011773pencils
pensils92811593pensils
pintails10310163pintails
pontils9312213pontils
quails153412643_quails
rails55937403__rails
remails94714563remails
renail65020763renail_
resails74616743resails
retails74718973retails
runnels7329153runn_els
sails55738103__sails
serails73318363serails
snail57020203_snail_
snarls64016873_snarls
spails84817823_spails
stunsails942883stunsails
sundials946753sundials
sunnahs10326593sunna_hs
sunnas63914563sunna__s
sunnily1037833sunn_ily
swails94913123_swails
tails55634193__tails
tenail64516113tenail_
toenails847213toenails
tonsils7310183tonsils
trails64622513_trails
trenails869843trenails
tunnages9195903tunnages
tunnels7328723tunn_els
tunnies73614263tunn_ies
ulnas55716533ulna__s
unable83819223u_nable
unagile838283unagile
unai44824783u_nai__
unarms839243u_narms
unaus53216573u_na_us
unbale83616403unba_le
unbales92914863unbales
unbans81912623unba_ns
unbars82113033unba_rs
unbraids1144963unbraids
unbuild1035723unbuild
unbuilds1143153unbuilds
unbuilt948003unbuilt
uncages103213773uncages
uncakes133012743uncakes
uncaps1039813unca_ps
uncases93516553uncases
unchains1338303unchains
unchairs1345503unchairs
uncial83715223uncial_
unclips1136433unclips
uncoil8811853uncoil_
uncurls937123uncurls
undies73821963u_ndies
uneases73316263uneases
uneasily1146453uneasily
unfair936233unfai_r
unfairly1443563unfairly
unfaith1345783unfaith
unfaiths1443213unfaiths
unfits93910293u_nfits
unfurls1035573unfurls
ungainly1244423ungainly
unguis738453ungui_s
unhailed12219963unhailed
unhair937333unhai_r
unhands1137773unhands
unhangs1136203unhangs
unhats91110623unha_ts
unifies102714713unifies
unities72520153unities
units54923433u_n_its
unjams1555703unja_ms
unknits1135553unknits
unlaces92513623unlaces
unlades82612833unlades
unlaid7311753unlai_d
unlays93810493unla_ys
unmailed11229763unmailed
unmakes132810793unmakes
unmanly1236993unmanly
unmans82211993unma_ns
unmasks1344553unmasks
unnailing1037023unnailing
unnamed102410273unnamed
unnoisy1044243unnoisy
unpacks1576093unpacks
unpaid939473unpai_d
unpile81914323u_npile
unpiles92112783u_npiles
unpins82312383u_npins
unplaits1044813unplaits
unravels1144633unravels
unreels7258313unreels
unrigs7159003u_nrigs
unrips8199453u_nrips
unrolls797793unrolls
unsaid7411833unsai_d
unsays9399543unsa_ys
unseals73212573unseals
unsells73210773unsells
unships1237203unships
unsnags835463unsna_gs
unsnaps935423unsna_ps
unsnarl7107153unsnarl_
unspilt938853unspilt
untacks1357503untacks
unties64326923u_nties
until53517743u_ntil_
untrims938613untrims
unveil957343unveil_
unwarily1446363unwarily
unwits9389893u_nwits
unzips17175273u_nzips
upboils1184703upboils
upcoils1184933upcoils
uracils939373uracils
uranias72113813uranias
uranyls1034453uranyls
urials64415193uria_ls
urinals7610253urina_ls
usuals637783usua_ls
utensils8124963utensils
vails85825933__vails
ventails1139823ventails
vinals94716483vina_ls
wails86631483__wails

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272206.17321711.8
3Display Results2202200.0762894.7
 (SQL Overall)1786912206.65526850.6
 
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.