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

258 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
agnail73953(None) 
agnails837001agnails
again65218122ag_ain
agnate73314882agnate
agnatic10310972agnatic
agonal7410052agona_l
anal48037522a_na_l
anil46437432a_n_il
annal56520762anna_l
anvil82712602a_nvil
assail6610152assail
avail8313882a_vail
gnarl65115572_gnarl
grail64622872_grail
hangnail1253662hangnail
nail45838652__nail
renail65020762renail
snail57020202_snail
tenail64516112tenail
unnail6410582unnail
wagtail1145042wagtail
aal39058673a__a_l
abigail1044193abigail
aboil72217543a_boil
abseil837183abseil
adnate72913483adnate
aecial84817313aecial
aerial64625713aerial
affair1234353affair
afraid1049723afraid
aga410447233ag_a__
agama85815583ag_ama
agamic113110563agamic
agamid103710693agamid
agapai9456863agapai_
agape85614843ag_ape
agar58726413ag_a_r
agaric93513643agaric
agars66120643ag_ars
agas55938843ag_a_s
agate66525153ag_ate
agave95314033ag_ave
agaze156113663ag_aze
agential958153agential
aggada955223aggada
aggadic1254813aggadic
aggie73415013ag_gie
agha87417303agha__
aghas97014873agha_s
aghast105711373aghast
agile65122263ag__ile
agin56132713ag__in
agio57828453ag__io
aglare7312433aglare
agma77623263agma__
agmas85919873agma_s
agnates82813193agnates
agnatical1246163agnatical
agnation9311723agnation
agnize16329563agnize
agnosia837643agnosia
agonic93515143agonic
agrafe1038093agrafe
agravic1345893agravic
agria65517143ag_ria
agrias74315393agrias
ail37171043___ail
airmail946213airmail
alanin6317273alanin
alanyl955483alanyl
alcaic1039983alcaic
algal66518223alga_l
alkali10127563alkali
amain74922913a_main
amnia75918643amn_ia
amnic95516243amn_ic
amnio75218053amn_io
ana39559833a_na__
anally9513503a_nally
anas46649863a_na_s
anga56831363anga__
angaria8311583angaria
angary10311323angary
angas65827993anga_s
angel65019573a_ngel
anginal8310163angina_l
angrily1137723angrily
ani37751183a_n_i_
anile54634463a_n_ile
anils56326723a_n_ils
anis45746463a_n_is
anna45529013anna__
annals66415923annals
annas55824883anna_s
anneal64812293anneal
annual64710703annual
annul55813383a_nnul
annuli6459053annuli
anti45536363a_nti_
antic75728863a_ntic
antis55033313a_ntis
anvils9219713a_nvils
apneal83411123apneal
apneic1078623apneic
appal95315223appa_l
appall10379743appall
archil11611573archil
areal55928733area_l
argal65023393arga_l
argali75013753argali
argil65116883a_rgil
aril45843023a__ril
artal55525473arta_l
arval86017013arva_l
assai5711543assai_
assails769093assails
assais6711963assais
assoil688543assoil
atlatl637873atlatl
atonal6514023atona_l
atrial65418943atrial
attain6311753attain
atwain937813atwain
audial7312993audial
auntie64317703auntie
aural54428963aura_l
avails939693a_vails
aventail1145343aventail
await85524493a_wait
axal116520493a_xa_l
axial124515193axia_l
axil116424453a__xil
axonal1347653axona_l
azonal1568273azona_l
bagnio937523bagn_io
bail65042803__bail
banal75925993bana_l
bangtail1144353bangtail
bewail1189583bewail
binal75323823bina_l
brail75525553_brail
camail10314833camail
canal75428043cana_l
carnal83919213carna_l
cattail939183cattail
denial74720513denial
dentil74017883dentil
derail74218813derail
detail74516433detail
drail65020973_drail
egal55119433eg_a_l
email74715103_email
engrail846263engrail
entail61114343entail
fail74840243__fail
fantail10310233fantail
faunal94711593fauna_l
final83922033fina_l
finial92814183finial
flail85316183_flail
frail85220213_frail
gaily95020973_g_aily
gain56042163_g_ain
gait56150193_g_ait
gal46055513_g_a_l
gall56335993_g_all
ganoid8314443ganoid
gaol56925413_g_aol
gavial10310083gavial
gayal9312713gaya_l
genial74917613genial
gentil74115123gentil
glair65313553_glair
glial66715433_glial
gnar56021383_gna_r
gnarls74210773_gnarls
gnarly104610383_gnarly
gnarr64810693_gnarr
gnars66718853_gnars
gnash9449833_gnash
gnat56034433_gna_t
gnats65217713_gnats
gnaw86515743_gna_w
gnawn9517783_gnawn
gnaws96311143_gnaws
goal55829303_goa_l
graal64316503_graal
grails77518783_grails
grain65126253_grain
hail74839063__hail
hangnails1353003hangnails
hobnail1243973hobnail
ignatia846133ignatia
jail115529093__jail
jezail2234643jezail
kail85131493__kail
lanai5319573lanai_
lanais6316793lanais
lentil64315393lentil
lugsail843443lugsail
magnate10512703magnate
mail65543453__mail
mainsail1045173mainsail
menial84223033menial
naif76839023__naif
nails55730403__nails
nil36144193__n_il
noil46133243__noil
oxtail1337653oxtail
paginal10269493pagina_l
pail66141833__pail
penal75228373pena_l
pencil103712973pencil
penial84120893penial
pensil83013333pensil
pigtail1046623pigtail
pintail9311183pintail
pontil8315463pontil
quail144314363_quail
rail46147763__rail
rattail737803rattail
regnal74812933regna_l
remail85017123remail
renails74917263renails
renal55929503rena_l
resail64418733resail
retail65522073retail
sail45447163__sail
serail64222673serail
signal73711483signa_l
snails64816653_snails
snarl54921083_snarl
spail74921553_spail
swail86217163_swail
tail45443653__tail
tarnal63716503tarna_l
tenails73713923tenails
toenail738783toenail
tonal53724303tona_l
tonsil6311873tonsil
trail55126773_trail
trenail7410813trenail
unai44824783_unai_
unais53420773_unais
unnails738223unnails
until53517743_until
vagal94613633vag_a_l
vaginal11288403vagina_l
vail75432553__vail
venal85523213vena_l
venial94218283venial
ventail10310453ventail
vinal85725813vina_l
wagtails1244443wagtails
wail75238823__wail
wassail1056133wassail
xenial133414903xenial
zonal145116853zona_l

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.373479064.3
2DLD Change Limit1127162585.01622471.3
3Display Results2582580.0763394.7
 (SQL Overall)1786912585.46532697.3
 
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.