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

266 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
nattily10361032(None) 
cattily123210851cattily
fattily13379461fattily
nastily103011031nastily
nuttily10308631nuttily
tattily10409991tattily
artily92814712_artily
chattily1634602chattily
dottily1147282dottily
hastily133010662hastily
knottily1543152knottily
nattier73614622nattier
natty85719142natt__y
nautili746112nautili
nettly9459452nett_ly
niftily1335752niftily
pettily1238172pettily
rattly94111542ratt_ly
ruttily10338612ruttily
saltily10310542saltily
snottily1145552snottily
tartily103511572tartily
tastily103311642tastily
wittily1336172wittily
aerily93017013_aerily
airily93014823_airily
angrily1137723angrily
anthill1048203anthill
anticly12410053anticly
aptly105111813_apt_ly
atilt54828473_a_tilt
attic75618353_atti_c
attics84413283_attics
attire62412383_attire
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
bastile9313913bastile
battery124911813battery
battier93515713battier
battik1238093batti_k
battiks1337143battiks
batting104422273batting
battle85217863batt_le
batty105422243batt__y
bawdily1635803bawdily
cagily12411563ca_gily
campily1638273campily
cannily1239263cannily
cattail939183cattail_
cattails1038553cattails
cattalo938423cattalo
cattery123811603cattery
cattie85221023catti_e
cattier93317073cattier
catties94023053catties
catting103922643catting
cattish12410723cattish
cattishly1743473cattishly
cattle85118903catt_le
catty104520413catt__y
craftily1644783craftily
daffily1735133daffily
daftly1335443daft_ly
daily95922333da__ily
daintily1245523daintily
dandily12279633dandily
datedly1236023datedly
daylily1434983daylily
dirtily1138583dirtily
draftily1534413draftily
dustily113211523dustily
earthily1445613earthily
earthly13387383earthly
easily9313023ea_sily
emptily1445813emptily
family143311703fa_mily
fancily1538253fancily
fatally1339893fatally
fatly115716803fa_t_ly
fattier103513463fattier
fatties103018203fatties
fatting113818703fatting
fattish1359263fattish
fatty115117413fatt__y
fatuity1336043fatuity
faultily1474523faultily
fustily133111373fustily
gaily95020973ga__ily
gamily123712183ga_mily
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
gnattier934263gnattier
gnatty10336483gnatt__y
goutily1137933goutily
grittily1244183grittily
gustily113010903gustily
gutsily11267223gutsily
hammily1736063hammily
handily143610873handily
happily1745763happily
hardily143310273hardily
hatting113920233hatting
hazily2179063ha_zily
heartily1436563heartily
heftily1635763heftily
inaptly1244413inapt_ly
jauntily1834173jauntily
jazzily2533373jazzily
joltily1746323joltily
lacily11612763la_cily
laithly1335653laithly
lankily1437123lankily
lastly93310873last_ly
lately93413843la_tely
latterly1136063latterly
lattice938433lattice
lattin64316223latti_n
lattins74115483lattins
lazily1859713la_zily
loftily1336353loftily
lustily103611243lustily
mangily1339753mangily
manlily1238743manlily
mattedly1443883mattedly
mattery123810713mattery
mattin84416633matti_n
matting103620143matting
mattins93316143mattins
mazily20610393ma_zily
meatily12311093meatily
mistily122612343mistily
mustily123613633mustily
nail45838653na__il_
nails55730403na__ils
naively1335903naively
nakedly1534403nakedly
namely113711323na_mely
nargile847653nargile
nasally1057443nasally
nastic82915973nasti_c
nastier74115293nastier
nasties73520493nasties
nasty85717283nast__y
natal53921493na_tal_
natality1139193natality
natantly1144293natantly
natation81513933natation
natatory1146603natatory
nation64322803na_tion
native9613013na_tive
natively1446413natively
nativity1446633nativity
natrium948983natrium
natter64420743natt_er
natters73718063natters
nattiest83215353nattiest
naughtily1642283naughtily
nautilus844073nautilus
navally1366473navally
nazify2134233na_zify
neatly93812483neat_ly
needily1166323needily
nervily1336863nervily
nettier74211813nettier
netting84018763netting
nettle64514583nett_le
netty85816763nett__y
ninthly1344213ninthly
nippily1444713nippily
nitrify1335793nitrify
nitril62511533nitril_
nitrile73011373nitrile
nitrils72810703nitrils
nittier73512243nittier
nitty85418313nitt__y
nobbily1436693nobbily
noily86120993n__oily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683n_osily
notably12199993notably
notedly1136883notedly
notify1236943n_otify
nuttier73112023nuttier
nutting83316233nutting
nutty84816873nutt__y
paltrily1345413paltrily
pantile93918483pantile
partly116315473part_ly
pastil85018323pastil_
pastils94416173pastils
patchily1885813patchily
patly105020583pa_t_ly
pattie84020963patti_e
patties93425143patties
patting103722343patting
patty104723613patt__y
pawkily1934203pawkily
pithily1567033pithily
prettily1337283prettily
racily11715173ra_cily
rainily10310433rainily
ramtil8311023ramtil_
ramtils938413ramtils
raptly11338913rapt_ly
ratably121711513ratably
ratify122610043ra_tify
rattail737803rattail_
rattails837133rattails
rattier74015593rattier
ratting83822363ratting
rattish10510823rattish
rattle64717613ratt_le
ratty84819593ratt__y
ritzily1945143ritzily
rustily103112993rustily
sappily1437163sappily
sassily1038723sassily
satiny93817983sa_tiny
saucily1237913saucily
savvily1634323savvily
scantily1337583scantily
smuttily1344273smuttily
snakily1436913sna_kily
snappily1544323snappily
snarkily1534583snarkily
snootily1136253snootily
sootily101810523sootily
spottily1335153spottily
squattily2142653squattily
stagily1139053stagily
stately10310223stately
tacitly1236223tacitly
tackily1637503tackily
tactile9310613tactile
tantivy1335563tantivy
tardily11269583tardily
tartly96014023tart_ly
tattie64817513tatti_e
tattier74216243tattier
tatties74120343tatties
tatting84019523tatting
tattle64115653tatt_le
tatty84720183tatt__y
tautly9499503taut_ly
tawnily1335443tawnily
testily102910803testily
tuftily1335573tuftily
unaptly1244793unapt_ly
vastity1336203vastity
vastly12508723vast_ly
vatting113614853vatting
wackily1936053wackily
warily122915093wa_rily
waspily1535513waspily
waterily1438783waterily
wattle94314213watt_le
wavily15219483wa_vily
waxily19218413wa_xily
wrathily1744773wrathily
yeastily1444573yeastily
zanily18310183za_nily
zestily19167563zestily

Search took 8 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.423422437.4
2DLD Change Limit1340272666.82619634.8
3Display Results2662660.0932860.2
 (SQL Overall)1786912667.34224338.2
 
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.