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

227 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
dottily114728(None) 
cattily123210852cattily
dirtily1138582dirtily
doily95321032do__ily
doomily1336132doomily
dopily123510462do_pily
dottel73610892dottel_
dottels8327782dottels
dottier83910922dottier
dotting93314482dotting
dottle74212502dott_le
dotty94516102dott__y
dowdily1534952dowdily
dozily19329102do_zily
dustily113211522dustily
fattily13379462fattily
goutily1137932goutily
joltily1746322joltily
knottily1543152knottily
loftily1336352loftily
nattily103610322nattily
nuttily10308632nuttily
pettily1238172pettily
ruttily10338612ruttily
snottily1145552snottily
sootily101810522sootily
spottily1335152spottily
tattily10409992tattily
wittily1336172wittily
artily92814713_artily
bodily12310993bo_dily
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
botchily1864373botchily
botfly1436093bo_tfly
bottle84916073bott_le
boxily1877843bo_xily
chattily1634603chattily
cockily1838493cockily
cornily12410853cornily
cosily113613853co_sily
costly114012333cost_ly
cottier93814173cottier
cottony1237253cottony
cozily20349703co_zily
daffily1735133daffily
daftly1335443daft_ly
daily95922333d__aily
daintily1245523daintily
dandily12279633dandily
datedly1236023datedly
daylily1434983daylily
deathly14336863deathly
deftly1336533deft_ly
dentil74017883dentil_
dentils84115583dentils
destiny113111463destiny
detail74516433detail_
details84214043details
dewily1338343d_ewily
dingily1238103dingily
distil73616433distil_
distill83011323distill
distils83015803distils
dittany1135653dittany
ditties83116983ditties
ditty95019293ditt__y
dizzily1934843dizzily
doating93816863doating
docile94213123do_cile
doctorly1443113doctorly
dolly96125203do__lly
doltish11118733doltish
doltishly1643383doltishly
dooly94821803do__oly
dorty96220813dort__y
dossil75110903dossil_
dossils8669773dossils
dotal64919623do_tal_
dotardly1343843dotardly
dotation91412733dotation
dotier73917033do_tier
doting84821913do_ting
dotingly1337343dotingly
dotted84717523dott_ed
dotter74419343dott_er
dotters83715973dotters
dottiest92611393dottiest
dottles83912283dottles
dottrel834463dottrel
dottrels963493dottrels
doty86128223do_t__y
doubly12328963do_ubly
doucely1344883doucely
doughtily1742373doughtily
dourly103210433do_urly
doyly124514013do__yly
draftily1534413draftily
drily95816523d__rily
droopily1443943droopily
drowsily1583723drowsily
ductile1048483ductile
dumpily1566233dumpily
duskily15236743duskily
emptily1445813emptily
foamily1546543foamily
foggily1535053foggily
fortify1636523fortify
foxily1947253fo_xily
frostily1436693frostily
frothily1745303frothily
fustily133111373fustily
godlily1235343godlily
goofily14105353goofily
gorily10612503go_rily
grittily1244183grittily
gustily113010903gustily
gutsily11267223gutsily
hastily133010663hastily
heftily1635763heftily
hoarily1338973hoarily
hokily16409093ho_kily
holily123612953ho_lily
homily144712333ho_mily
hornily1338283hornily
horsily1338843horsily
hostile10312553hostile
hostly124210863host_ly
hotly115815483ho_t_ly
hottie92514383hotti_e
hotties103016963hotties
hotting113116523hotting
hottish13117903hottish
jokily20306533jo_kily
jollily1745773jollily
jotting152912773jotting
jotty155012603jott__y
loathly1334713loathly
logily1039833lo_gily
loonily1037073loonily
loopily1236803loopily
lottery10389833lottery
lotting82917753lotting
lousily1038333lousily
lowlily1335353lowlily
lustily103611243lustily
meatily12311093meatily
mistily122612343mistily
monthly1535673monthly
moodily1358203moodily
moonily1248943moonily
mortify1536223mortify
mostly113110943most_ly
motile83818343mo_tile
mottle84116053mott_le
mousily1239393mousily
mouthily1645903mouthily
mustily123613633mustily
nastily103011033nastily
nettly9459453nett_ly
niftily1335753niftily
nobbily1436693nobbily
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683no_sily
notably12199993notably
notedly1136883notedly
notify1236943no_tify
oilily93111723_oilily
oily77932253_o__ily
oozily18328073_oozily
outfly1238273_outfly
pithily1567033pithily
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
pontil8315463pontil_
pontils9312213pontils
portly114713403port_ly
pottery123011073pottery
pottier93516493pottier
potties93723543potties
potting103720893potting
pottle84416103pott_le
potty105621003pott__y
prettily1337283prettily
rattly94111543ratt_ly
ritzily1945143ritzily
roily86121113ro__ily
roomily1237283roomily
ropily113312443ro_pily
rosily93914713ro_sily
rototill844433rototill
rottenly1144153rottenly
rotting82919683rotting
roupily1246653roupily
rowdily1436083rowdily
rustily103112993rustily
saltily10310543saltily
smuttily1344273smuttily
snootily1136253snootily
soapily1237963soapily
softly12457763soft_ly
soggily1235953soggily
soothly13186923soothly
sorrily1039833sorrily
sottedly1244303sottedly
sottish10129443sottish
sottishly1543763sottishly
sportily1337733sportily
stonily1049433stonily
tartily103511573tartily
tastily103311643tastily
testily102910803testily
toothily1445523toothily
tortile7313193tortile
totally1039893totally
tottery10388483tottery
totting82816843totting
tuftily1335573tuftily
woozily2234383woozily
wordily1437853wordily
worthily1745253worthily
wotting112913843wotting
zestily19167563zestily

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.403443402.0
2DLD Change Limit1340272275.83022989.2
3Display Results2272270.0762986.8
 (SQL Overall)1786912276.30928323.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.