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

183 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
leprous93884(None) 
cerous85821202ce_rous
cuprous1149742cuprous
ferrous1049792ferrous
leprose938542leprose
leprosy1244222leprosy
leprously1445322leprously
leptons91910432leptons
lupous849432lup_ous
petrous92714422petrous
repros84216002repro_s
serous65023562se_rous
acerous9513333acerous
aeneous739893aeneous
aleurons867013aleurons
amorous9311133amorous
anurous7311553anurous
apercus1136573apercus
aprons8316993_aprons
aurous64119263_aurous
biparous1246923biparous
cercus105013153ce_rcus
cereus85215523ce_reus
ceros74726073ce_ro_s
cirrous93111063cirrous
citrous93112993citrous
copious11311963copious
cupreous1255603cupreous
cyprus1335363cypr_us
decorous1138853decorous
deploys1336523deploys
deports105012883deports
depots94716343dep_ots
depress10239873depress
desirous947783desirous
devious1138523devious
dextrous1646593dextrous
ecrus75113863_ecr_us
elytrous1145503elytrous
enrols61213383_enrols
ephods1238363_ephods
ephors11311403_ephors
epos66723733_ep_o_s
eros45238453_e_ro_s
errors63311313_errors
estrous7712533estrous
euros54920243_euro_s
ferreous1146033ferreous
feverous1446513feverous
fibrous1237593fibrous
fleurons1155343fleurons
flexuous1842413flexuous
generous939773generous
genros74211333genro_s
glabrous1145533glabrous
heinous1038853heinous
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
hydrous14197883hydrous
impious1137063impious
imporous1246303imporous
improvs1435003improvs
jealous1438093jealous
kleptos1344363klepto_s
ladrons83813193ladrons
lapdogs1134073lapdogs
lapsus8437273lap_sus
laptops1166603laptops
leapfrogs1551713leapfrogs
learns65513743lear_ns
lears55938733lear__s
lecherous1445033lecherous
lectors93415763lectors
leers54828983leer__s
legions84611783legions
legroom1076093legroom
legrooms1185413legrooms
lehrs86111133lehr__s
lemons84415053le_mons
lenos56024863le_no_s
lentos65317403lento_s
lepers84817323lep_ers
leporid1048153leporid
leporids1145673leporids
leprosies1146803leprosies
leprotic1248583leprotic
leptins92412693leptins
lepton82510803lepto_n
lesbos837403lesbo_s
lesions73813873lesions
lessons73811023lessons
lessors73610523lessors
leukons1135753leukons
lupus74512523lup__us
lustrous877803lustrous
luteous739273luteous
meous76120063me__ous
metros84217803metro_s
nephrons1346853nephrons
nerols6914883ne_rols
nervous1037143nervous
neurons7410443neurons
nitrous73512483nitrous
ochrous1237943ochrous
odorous837663odorous
oestrous869923oestrous
onerous7312973onerous
operons91411743operons
pappous1057463pappous
parous84024163_parous
pedros9312183pedro_s
pelorus939273pelorus
peplos101211543peplo_s
peplus10138343pep_lus
pepos96620083pep_o_s
perdus93711273pe_rdus
perrons93115483perrons
petrols92913083petrols
pious74621273__pious
porous84419483_porous
praus74621753__praus
proas75028803__proas
prods85523553__prods
profs105120893__profs
progs86624153__progs
proms95426413__proms
props95726883__props
pros65742783__pro_s
pross76529403__pross
proud84615483__proud
prows106327013__prows
rearouse839363rearouse
recross989833recross
regroup1095173regroup
regroups11104383regroups
regrows11269153regrows
replots93412633replots
replows12329703replows
reports94916213reports
repos74725793rep_o_s
repots85621003rep_ots
repour8310993rep_our
repours9310233rep_ours
repress92712683repress
repro75315913repro__
reprobe112310133reprobe
reprobes121910293reprobes
reproof1238783reproof
reproofs1346063reproofs
reprove122911073reprove
reproves132011473reproves
resprout1078783resprout
resprouts1174823resprouts
retros63820193retro_s
saporous1039053saporous
sclerous1047923scle_rous
sepalous1047523sepalous
sepoys1138473sep_oys
serious73616283serious
serows96016393se_rows
setous64917373se_tous
spermous1247933spermous
sprout8419403_sprout
sprouts949983_sprouts
tedious838443tedious
tenuous738483tenuous
tepoys1137543tep_oys
terrors73112213terrors
torous64319033_torous
typhous1566323typhous
ulcerous1046163ulcerous
upprops1044223upprops
uprouse937223_uprouse
vaporous1346483vaporous
venous93713193ve_nous
versus94211143ve_rsus
vertus94613603ve_rtus
viperous1347613viperous
xerus12313333xe_r_us
zealous1637813zealous
zeroes154314343ze_roes
zeros144918113ze_ro_s

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.406440125.6
2DLD Change Limit1340271836.17021722.4
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.63926915.3
 
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.