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

287 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
oozily1832807(None) 
boozily2135621boozily
cozily20349701cozily
dozily19329101dozily
woozily2234381woozily
bodily12310992bodily
boxily1877842boxily
cosily113613852cosily
doily95321032do_ily
doomily1336132doomily
dopily123510462dopily
foxily1947252foxily
goofily14105352goofily
gorily10612502gorily
hazily2179062hazily
hokily16409092hokily
holily123612952holily
homily144712332homily
jokily20306532jokily
lazily1859712lazily
logily1039832logily
loonily1037072loonily
loopily1236802loopily
mazily20610392mazily
moodily1358202moodily
moonily1248942moonily
noily86120992no_ily
nosily93712682nosily
oilily93111722oilily
oily77932252_o_ily
oozier153610252oozier
oozing163812202oozing
oozy167018132ooz__y
pokily15309062pokily
roily86121112ro_ily
roomily1237282roomily
ropily113312442ropily
rosily93914712rosily
sootily101810512sootily
aerily93017013aerily
airily93014823airily
artily92814713artily
bezil163812883bezil_
bezils1711310603bezils
bloodily1445183bloodily
blowzily2542733blowzily
boil66335183bo_il_
boils75427193bo_ils
boldly12399423boldly
bonnily1236873bonnily
boozier18349013boozier
boozing194012163boozing
boozy194917063booz__y
bossily1237563bossily
botfly1436093botfly
broodily1445503broodily
busily112211503busily
cagily12411563cagily
coaly105521593co_aly
cockily1838493cockily
codify1537163codify
coil66439653co_il_
coils75030083co_ils
coldly12459953coldly
colly104926773co_lly
coly96940533co__ly
comely134213733comely
comity13312713comity
comply152810383comply
coolly114811393coolly
cooly105525423co_oly
cornily12410853cornily
costly114012333costly
coyly135614893co_yly
cozey196718543coz_ey
cozie163519123cozi_e
cozied184112153cozied
cozier173315143cozier
cozies174521413cozies
cozy185823803coz__y
crazily2136923crazily
daily95922333_daily
dewily1338343dewily
dizzily1934843dizzily
docile94213123docile
dolly96125203do_lly
dooly94821803do_oly
doozie163910643doozi_e
doozies173812723doozies
doozy186813713dooz__y
dottily1147283dottily
doubly12328963doubly
dourly103210433dourly
dowdily1534953dowdily
doyly124514013do_yly
dozier163611633dozier
dozing174214193dozing
dozy175920323doz__y
drily95816523_drily
droopily1443943droopily
easily9313023easily
edgily1136063edgily
eerily92913563eerily
family143311703family
foamily1546543foamily
foggily1535053foggily
foil76433913fo_il_
foils85025813fo_ils
folly115022603fo_lly
fondly13299043fondly
foozle18369203fooz_le
foully1239013foully
fozier183710663fozier
fozy197017163foz__y
frowzily2642673frowzily
fuzil173810703fuzil_
fuzils18407963fuzils
fuzzily2145073fuzzily
gaily95020973_gaily
gamily123712183gamily
gauzily2034393gauzily
glazily2035383glazily
gloomily1443753gloomily
gluily10308293gluily
godlily1235343godlily
godly104913293go_dly
goggly12337053goggly
golly95121103go_lly
goodly11419303goodly
googly11417883googly
goutily1137933goutily
hoarily1338973hoarily
holly114824433ho_lly
holy106333433ho__ly
homely145313173homely
hominy144511483hominy
hooly115022223ho_oly
hornily1338283hornily
horsily1338843horsily
hostly124210863hostly
hotly115815473ho_tly
hourly12369623hourly
icily101211693_icily
ickily1535753ickily
jazzily2533373jazzily
jollily1745773jollily
jolly154517513jo_lly
joltily1746323joltily
jowly186410903jo_wly
lacily11612763lacily
lily76730183__lily
loftily1336353loftily
lolly85120663lo_lly
lonely92912473lonely
longly10279603longly
loosely1036713loosely
lordly1038753lordly
loudly1037783loudly
lousily1038333lousily
lovely12339713lovely
lowlily1335353lowlily
lowly114113333lo_wly
mizzly19256103mizzly
mobile103613543mobile
modify1537173modify
moil65534093mo_il_
moils76125753mo_ils
molly105222493mo_lly
moly96031913mo__ly
mostly113110943mostly
motile83818343motile
mousily1239393mousily
muzzily2045023muzzily
nazify2134233nazify
nobbily1436693nobbily
nobly105314403no_bly
noil46133243no_il_
noils55024333no_ils
noisily1038403noisily
noisy86813363no_isy
nonoily1049543nonoily
notify1236943notify
nozzle14236633nozzle
oddity1135243oddity
oddly1037163_oddly
oil37452053_o_il_
oils46337973_o_ils
only75319723_o_nly
oogamy1235633oogamy
oogeny10117923oogeny
oohing104412933oohing
oolite63319603oolite
oolith93813243oolith
oology103210253oology
oomiac1037063oomiac
oomiak1235353oomiak
oorali6311263oorali
oorie53026363oori_e
ootid61416693ooti_d
ootids71110353ootids
ooze136420603ooz__e
oozed154214263ooz_ed
oozes145418713ooz_es
ooziest163411523ooziest
openly1137123openly
orally93113593orally
ossify1244973ossify
outfly1238273outfly
ouzel144612323ouzel_
ouzels15408703ouzels
ovally12278443ovally
overly122411363overly
phonily1537103phonily
pily96132733__pily
pockily1846233pockily
podgily1435213podgily
poilu72316003po_ilu
policy133211513policy
polity113015863polity
poly96235153po__ly
poorly1137893poorly
portly114713403portly
poshly1437723poshly
pozole1758913pozole
prosily12611633prosily
punily11311773punily
racily11715173racily
ritzily1945143ritzily
roil46235293ro_il_
roils54826793ro_ils
rosiny94414533rosiny
roupily1246653roupily
rowdily1436083rowdily
sexily1638853sexily
shily115222013_shily
showily1636213showily
slily85820033_slily
smokily1635373smokily
snoopily1345553snoopily
snootily1136243snootily
snowily1336883snowily
soapily1237963soapily
softly12457763softly
soggily1235953soggily
soil46138823so_il_
soils55327983so_ils
solely93714213solely
solidly1137353solidly
sonly85718053so_nly
soothly13186913soothly
sorely94618003sorely
sorrily1039823sorrily
sourly93612203sourly
sozin14514533sozi_n
sozine15712343sozine
sozins15510783sozins
spookily1744173spookily
spoonily1335233spoonily
stonily1049433stonily
tidily102811393tidily
tinily94014433tinily
toil46536283to_il_
toile54626493to_ile
toils54527493to_ils
toothily1445523toothily
uglily1036193uglily
verily122616053verily
voila84813943vo_ila
voile84719723vo_ile
warily122915093warily
wavily15219483wavily
waxily19218413waxily
wilily123310763wilily
wily106428813__wily
wirily123310783wirily
wobbly16347093wobbly
woollily1443123woollily
woolly12408513woolly
wooly114417673wo_oly
woozier19347323woozier
woozy204410603wooz__y
wordily1437853wordily
zanily18310183zanily
zill135727613__zill
zoophily2544913zoophily
zoril143916693zoril_
zorils153810883zorils

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162876.42317548.8
3Display Results2872870.0933086.0
 (SQL Overall)1786912876.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.