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

298 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
prosily1261163(None) 
rosily93914711_rosily
cosily113613852_cosily
crossly1277272crossly
crusily12199092crusily
drowsily1583722drowsily
erosely1038082erosely
frostily1436692frostily
grossly1175982grossly
horsily1338842horsily
nosily93712682_nosily
phonily1537102phonily
piosity1268642piosity
pokily15309062p_okily
porosity1348592porosity
poshly1437722p_oshly
pricily142710282pricily
prissily1346692prissily
privily15207622privily
probity14299682probity
prodigy1435572prodigy
profile123211152profile
prolixly2043112prolixly
pronely12310252pronely
prosier93817482prosier
prosing103319382prosing
prosit85124592prosi_t
prosody1336432prosody
prosy106319252pros__y
proudly1336332proudly
pursily1238212pursily
roily86121112_ro_ily
ropily113312442_ropily
rosiny94414532_rosiny
artily92814713ar_tily
blousily1345193blousily
blowsily1643953blowsily
bodily12310993_bodily
boozily2135623boozily
bossily1237563bossily
boxily1877843_boxily
brashly15427613brashly
brasil8713863brasil_
brasils9410973brasils
brassily1336623brassily
briskly16165403briskly
bristly12178063bristly
broadly1337153broadly
broil74918223bro_il_
broils84114173bro_ils
brolly114510853bro_lly
broodily1445503broodily
brosy106115383bros__y
busily112211503_busily
closely1237053closely
cornily12410853cornily
costly114012333_costly
cozily20349703_cozily
crassly1276653crassly
crazily2136923crazily
crispily1574693crispily
crisply14426523crisply
croakily1744733croakily
crosier94116573crosier
croupily1544743croupily
crousely1346563crousely
crustily13328173crustily
doily95321033_do_ily
doomily1336133doomily
dopily123510463_dopily
dozily19329103_dozily
dressily1246443dressily
drily95816523dr__ily
drolly105411673dro_lly
drooly104911073dro_oly
droopily1443943droopily
droshky1841973droshky
drosky14486163dros_ky
drossy10528473dros_sy
easily9313023_easily
erosible1046443erosible
erosion7311113erosion
erosive1039193erosive
flossily1434523flossily
foxily1947253_foxily
freshly16286833freshly
friskily1834503friskily
frosty124710633fros_ty
frothily1745303frothily
frowzily2642673frowzily
fussily13267603fussily
gassily1137813gassily
ghostly14355103ghostly
glossily1235093glossily
goofily14105353goofily
gorily10612503_gorily
grassily1236433grassily
greasily1236233greasily
grimily1336523grimily
grisly104310583gris_ly
gristly11187333gristly
groggily1443283groggily
groszy19395703gros_zy
growly13499173gro_wly
gutsily11267223gutsily
hokily16409093_hokily
holily123612953_holily
homily144712333_homily
hornily1338283hornily
hostly124210863_hostly
jokily20306533_jokily
logily1039833_logily
loonily1037073loonily
loopily1236803loopily
loosely1036713loosely
lousily1038333lousily
messily12298813messily
moodily1358203moodily
moonily1248943moonily
morosely1345713morosely
morosity1347293morosity
mostly113110943_mostly
mousily1239393mousily
mussily12279773mussily
noily86120993_no_ily
noisily1038403noisily
oily77932253__o_ily
oozily18328073_oozily
operosely1443283operosely
pawkily1934203pawkily
pensil83013333pensil_
pensile92713543pensile
pensils92811593pensils
peppily1335133peppily
perkily1637813perkily
peskily1635083peskily
pettily1238173pettily
pilosity1366323pilosity
pily96132733p___ily
piously1236833piously
pithily1567033pithily
ploidy1237483plo_idy
plosion939113plosion
plosive1236673plosive
plushily1664423plushily
plushly15385383plushly
pockily1846233pockily
podgily1435213podgily
poilu72316003p_o_ilu
policy133211513p_olicy
polity113015863p_olity
poly96235153p_o__ly
poorly1137893p_oorly
porously1347753porously
portly114713403p_ortly
posies84431433p_osies
posing93922643p_osing
posingly1436933p_osingly
posit75833333p_osi_t
posits85718713p_osits
posole8314223p_osole
possibly1544483possibly
posy96028423p_os__y
prebill1138803prebill
prefile123413183prefile
prepill1147583prepill
preppily1444593preppily
presale9416353presale
presell939303presell
preside10715613preside
presift12312223presift
presold1059603presold
prettily1337283prettily
prickly18367893prickly
pricy124814563pr__icy
priestly1345843priestly
prill74117943pr__ill
primely1457723primely
primly13439623pr_imly
priority1347443priority
priorly12335763priorly
prising103321453prising
prissy11347853pris_sy
privity15268313privity
privy13439833pr__ivy
probably1746413probably
probing123314443probing
probingly1746013probingly
probit103218353probi_t
probits112712573probits
profamily1943633profamily
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
profit113016273profi_t
profits122911243profits
profusely1743063profusely
progeny1389463progeny
prole74527793pro__le
proline92321593proline
prolix1538683proli_x
promine112819443promine
promise113415843promise
promptly1743913promptly
propel103714063propel_
propels113412843propels
properly1546463properly
propine113020213propine
propyl13358183propyl_
propyla14296633propyla
propyls14308193propyls
pros65742783pros___
prosaic11311163prosaic
prosaism1268043prosaism
prosaist10611583prosaist
prose75835123pros__e
prosect11313393prosect
prosed94921093pros_ed
proselyte1444843proselyte
proser84223463pros_er
prosers94219643prosers
proses84733473pros_es
prosiest10416523prosiest
proso77222413pros__o
prosoma11310223prosoma
prosos85718553pros_os
prosper114012193prosper
pross76529403pros__s
prosses94019513prosses
prossie91812953prossie
prossies101515223prossies
prost75434103pros__t
prostie91617743prostie
prosties101421193prosties
prostyle13187273prostyle
protist9320223protist
protium11312293protium
protyl11308213protyl_
protyle12229453protyle
protyls12298463protyls
provably1846213provably
provenly1646203provenly
provide1339853provide
proving134214073proving
proviso1237313proviso
prowl105615123pro_wl_
prowls115511083pro_wls
proxies163014933proxies
proximo1845143proximo
proxy175011013pro__xy
ptosis83611823ptosi_s
pudgily1434903pudgily
puffily1834843puffily
pulpily1436103pulpily
punily11311773p_unily
purposely1642933purposely
pushily15247983pushily
pussly11407373p_ussly
pyosis114012123pyosi_s
pyrosis12411653pyrosi_s
racily11715173_racily
rashly123410213_rashly
resile64627673_resile
resiny94617363_resiny
risibly1235643_risibly
riskily1436413_riskily
roil46235293_ro_il_
roils54826793_ro_ils
roomily1237283roomily
rosary92810353_rosary
rosery93813283_rosery
rosier64221263_rosier
rosin55325313_rosi_n
rosing73925593_rosing
rosins64521863_rosins
rosy76024873_ros__y
roupily1246653_roupily
rowdily1436083_rowdily
rustily103112993_rustily
sassily1038723sassily
serosity1148783serosity
showily1636223showily
smokily1635373smokily
snowily1336883snowily
sootily101810523sootily
sorrily1039833sorrily
spookily1744173spookily
spoonily1335233spoonily
sportily1337733sportily
stonily1049433stonily
tipsily1236043tipsily
torosity1147243torosity
trashily1437323trashily
trolly94012363tro_lly
trustily11257103trustily
woozily2234383woozily
wordily1437853wordily
wrongly1434553wrongly

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.406440125.6
2DLD Change Limit1340272987.12318816.1
3Display Results2982980.1102709.1
 (SQL Overall)1786912987.63923391.9
 
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.