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

195 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
miserly1232982(None) 
misery114113541miser_y
misrely12319611misrely
masterly13317652masterly
misally121111062misally
miser75430402miser__
miserably1646662miserably
misers85025702miser_s
mistily122612342mistily
mixedly2033982mixedly
sisterly1146332sisterly
wisely122711712wise_ly
amusedly1483183amusedly
angerly1137773angerly
basely114412313base_ly
biasedly1443953biasedly
bitterly1335603bitterly
biyearly1643393biyearly
cheerly15417603cheerly
cicely1338833cice_ly
direly10311563dire_ly
eagerly1136053eagerly
easterly11246643easterly
elderly1154953elderly
ferly115517353__ferly
fierily1339023fi_erily
fiery114714793fi_er_y
finely123011563fine_ly
finery124512893finer_y
firefly1635633firefly
fishery16397733fisher_y
fishily1637643fishily
fixedly2133913fixedly
gingerly13315303gingerly
girly94415293gi__rly
inertly1038543_inertly
innerly1037133innerly
liberty1237163liberty
liefly1266363li_efly
likely13328133like_ly
limberly1544463limberly
linearly1146793linearly
lively123310813live_ly
livery124910903liver_y
loverly1346973loverly
maidenly1444563maidenly
majorly1943153majorly
mannerly1344983mannerly
marly106925613m__arly
maser75029973maser__
masers84623453maser_s
massedly1444303massedly
mastery124214323master_y
mazedly2234433mazedly
meagerly1444003meagerly
mealy104422183m__ealy
meekly1535193m_eekly
meetly1138673m_eetly
mercy125916183m__ercy
merely111312593m__erely
merl65830973m__erl_
merle75824373m__erle
merls77423903m__erls
merry104721493m__erry
mesally12119793mesally
messily12298813messily
micell1098193mice_ll
micella11106823micella
micelle1178343micelle
micells11107683micells
mildly12318243mi_ldly
miler75733063miler__
milers84625163miler_s
milkily16216553milkily
mimer94825763mimer__
mimers105520183mimer_s
miner76933543miner__
mineral9312733mineral
minerals10311383minerals
miners84126633miner_s
mirkily16266403mirkily
mirky146315523mi__rky
miry96326753mi__r_y
misapply1742883misapply
misbill1137033misbill
miscall1139653miscall
miscarry1544473miscarry
miscopy1636663miscopy
misdeal1037663misdeal_
misdeals1147233misdeals
misdealt1147983misdealt
misdraw1345623misdraw
misdrew1335833misdrew
mise66043583mise___
misease92713043misease
miseat82925713mise_at
miseats92815793miseats
misedit10311043misedit
misemploy1852283misemploy
misenrol1044143misenrol
misenroll1152523misenroll
misenrols1144263misenrols
misentry1345773misentry
miserable1349653miserable
miserere1049273miserere
miseries10320403miseries
mises74740563mise__s
misfile122611553misfile
misgrew1335523misgrew
misgrow1344433misgrow
miskal123710263miskal_
miskals13369773miskals
mislay113510683mis_lay
misplay1436383misplay
misread10339723misread
misrule939353misrule
missal84314903missal_
missals93914433missals
missay114112143mis_say
missel85216523missel_
missels94614813missels
missile92815403missile
missilry1344653missilry
missy105617563mis__sy
mister84728563mister__
misterm114314513mister_m
misterms123711353misterms
misters93927513mister_s
mistral91013643mistral
mistrals101212633mistrals
misty106120453mis__ty
miswrit1249413miswrit
miter75734793miter__
mitered103213233mitered
miterer92511333miterer
miters84328783miter_s
mixer145017643mixer__
mixers154513563mixer_s
mizzly19256103mi_zzly
modernly1443843modernly
moistly1236613mois_tly
mopery135210973moper_y
mosey105922873mose__y
mostly113110943mos_tly
motherly16346093motherly
muscly1337453mus_cly
muser76024123muser__
musers84719103muser_s
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
mutedly1345753mutedly
mutely113811653mute_ly
myself1445593myse_lf
mystery15436523myster_y
nicely1139493nice_ly
nitery94412173niter_y
orderly1135763orderly
overly122411363_overly
pinery115214293piner_y
queerly1934233queerly
rifely123710033rife_ly
ripely112511153ripe_ly
riser55431053riser__
risers64624783riser_s
risibly1235643risibly
riskily1436413riskily
rosery93813283roser_y
seely84522633__seely
serry84824123__serry
sheerly13337703sheerly
sickerly1734033sickerly
silverly14284313silverly
soberly1236943soberly
surly85124433__surly
timely113410113time_ly
tinselly1144613tinselly
tiredly1136803tiredly
utterly1035443utterly
vicarly1536463vicarly
viceroy1544933viceroy
vilely1239443vile_ly
vinery124912603viner_y
visibly1535043visibly
vixenly2043193vixenly
westerly1445553westerly
widely133311033wide_ly
wifely15429423wife_ly
winery125014283winer_y
winterly14306743winterly
wiseguy1442353wiseguy
wiser85522803wiser__
wispily1535653wispily
writerly1444153writerly

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.436409841.7
2DLD Change Limit1340271955.93622578.7
3Display Results1951950.0802437.5
 (SQL Overall)1786911956.45227695.4
 
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.