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

181 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
leprose93854(None) 
leprosy1244221leprosy
depose94215762dep_ose
erose55727272_e_rose
heptose1237492heptose
leprosies1146802leprosies
leprous938842leprous
necrose939722necrose
operose939432operose
prose75835122__prose
repose84121412rep_ose
reprise92715042reprise
reprobe112310132reprobe
repros84216002repros_
reprove122911072reprove
rerose63320842re_rose
uprose82311482_uprose
acerose9310893acerose
aerobe8412403ae_robe
agarose838673agarose
aleurone846113aleurone
appose10411993_appose
apprise11310193apprise
approve14116603approve
arose55832083__arose
brose75227033__brose
cerise84822043ce_rise
ceros74726073ce_ros_
ceruse83914523ce_ruse
cirrose937473cirrose
defrost1139553defrost
deplore1039483deplore
depone93616553dep_one
deposed113412023dep_osed
deposer104011843dep_oser
deposes103117213dep_oses
deprave1337073deprave
depress10239873depress
deprive1338303deprive
dextrose1645363dextrose
emprise11310723emprise
enrobe86610793_enrobe
epode85114093_ep_ode
epos66723733_ep_os_
eposes84418783_ep_oses
erase54925493_e_rase
erode64520993_e_rode
eros45238453_e_ros_
eroses65327053_e_roses
euros54920243_euros_
expose1549523_expose
flexuose1841863flexuose
genros74211333genros_
geoprobe1343823geoprobe
gyrose105310253_gyrose
hearse94114273hear_se
heptoses1338373heptoses
heroes94923823he_roes
heros84930863he_ros_
hexose16267843he_xose
impose103113053imp_ose
imprese1138143imprese
improve1435963improve
ketose105711813ke_tose
kleptos1344363kleptos_
lacrosse1044123lacrosse
lactose969493lactose
ladrone83611873ladrone
lanose6313593l_anose
lapse74917683lap__se
learns65513743learns_
lears55938733lear_s_
lease55230263le__ase
leers54828983leer_s_
legroom1076093legroom
lehrs86111133lehr_s_
lenos56024863le_nos_
lense54523433le__nse
lentos65317403lentos_
leone55018823le__one
lepers84817323lepers_
lepidote1144683lepidote
leporid1048153leporid
leporine1049303leporine
leprotic1248583leprotic
leprously1445323leprously
lepton82510803lepto_n
leptons91910433leptons
leptosome1344203leptosome
lesbos837403lesbos_
leukoses1244613leukoses
levulose1143243levulose
lipase8239103lip_ase
loose56627683l__oose
lose45144583l___ose
metros84217803metros_
morose85116243_morose
necrosed1137213necrosed
necroses10310563necroses
nephroses1446303nephroses
neurone739433neurone
neuroses8310153neuroses
oppose1039193_oppose
papoose1147513papoose
pappose1047413pappose
pedros9312183pedros_
pentose9311593pentose
peplos101211543peplos_
peploses1269473peploses
pepos96620083pep_os_
peptone11310763peptone
perse75429523pe_r_se
peruse84016843pe_ruse
porose84818743_porose
pose66441733__p_ose
prase76128753__prase
prese75228383__prese
prise74632613__prise
probe94320813__probe
prole74527793__prole
prone75332623__prone
pros65742783__pros_
prosed94921093__prosed
proser84223463__proser
proses84733473__proses
proso77222413__proso
pross76529403__pross
prost75434103__prost
prosy106319253__prosy
prove104823193__prove
purpose1137383purpose
rearouse839363rearouse
rechose121312043rechose
recross989833recross
redrove11249423redrove
refroze1956223refroze
remorse9311713remorse
reoppose1245563reoppose
rephrase1346733rephrase
repos74725793rep_os_
reposed103616273rep_osed
reposer93715333rep_oser
reposes94021263rep_oses
repress92712683repress
reprice113212833reprice
reprised112012203reprised
reprises102615463reprises
repro75315913repro__
reprobed13228743reprobed
reprobes121910293reprobes
reproof1238783reproof
reproved14199473reproved
reprover13229203reprover
reproves132011473reproves
repulse938193repulse
repurpose1343133repurpose
rerise64325633re_rise
retrorse837623retrorse
retros63820193retros_
rewrote1039123rewrote
rose46148903___rose
saprobe1137333saprobe
sclerose1046223scle_rose
serosa6313023se_rosa
serosae7310243se_rosae
setose65114773se_tose
sucrose939303sucrose
suppose1137973suppose
terse55026823te_r_se
tetrode839343tetrode
torose64317693_torose
typhose1546693typhose
uprise82313693_uprise
uprouse937223_uprouse
venose9310843ve_nose
verbose1237753verbose
verse84723583ve_r_se
xeroses143612823xe_roses
zeppole2043493zeppole
zeroes154314343ze_roes
zeros144918113ze_ros_

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.393454684.5
2DLD Change Limit1340271816.56320421.6
3Display Results1811810.0762381.6
 (SQL Overall)1786911817.03225411.1
 
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.