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

196 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
leerily103763(None) 
eerily92913561_eerily
aerily93017012_aerily
beefily1535612beefily
blearily1365952blearily
cheerily1655422cheerily
deerfly1443982deerfly
fierily1339022fierily
fleecily1644012fleecily
leakily1436472leakily
leerier73111502leerier
leering83417642leering
leeringly1345962leeringly
leery85919132leer__y
legerity1245712legerity
merrily1238632merrily
needily1166322needily
reedily1179602reedily
seedily1178582seedily
sleepily1344822sleepily
tearily10311152tearily
verily122616052_verily
wearily1338782wearily
weedily1476122weedily
weevily1694642weevily
aerify122810113_aerify
airily93014823_airily
alderfly1542753alderfly
alertly1046793alertly
alterity1149843alterity
angrily1137723angrily
beadily1378843beadily
beamily1477393beamily
beerier93613023beerier
beery105220123beer__y
blurrily1343913blurrily
breezily2243653breezily
celerity1347643celerity
charily15310283charily
cheekily2053473cheekily
cheerly15417603cheer_ly
cheesily1654413cheesily
clearly1236663clear_ly
clerisy1246823clerisy
clerkly1643573clerkly
cleverly1643453clever_ly
creepily1574953creepily
dearly104615323dear_ly
deeply1257013dee_ply
dewily1338343_dewily
drearily1236083drearily
drily95816523__drily
early85324123_ear_ly
easily9313023_easily
edgily1136063_edgily
eely77725213_ee__ly
eerie55228533_eeri_e
eerier64320023_eerier
eery76129623_eer__y
elderly1154943elder_ly
febrile1237153febrile
feebly1436653fee_bly
ferity122813343_ferity
ferly115517353_fer_ly
fleering123811283fleering
fleeringly1743723fleeringly
fleetly1336313flee_tly
fleshily1744533fleshily
flowerily1842993flowerily
furrily1337613furrily
gemmily1534603gemmily
gorily10612503_gorily
greedily1345173greedily
headily1478623headily
heartily1436563heartily
heavily1665903heavily
heftily1635763heftily
hoarily1338973hoarily
inertly1038543inertly
jeering153513043jeering
jeeringly2045143jeeringly
jerkily2134623jerkily
keenly1336373kee_nly
lacily11612763l_acily
laetrile845193laetrile
lairdly1134913lairdly
lankily1437123lankily
lazily1859713l_azily
leally94012613l_eally
leanly93811503l_eanly
learier73415663learier
leary85927383lear__y
leer46239353leer___
leered73816223leer_ed
leeriest83112883leeriest
leers54828983leer__s
leewardly16102103leewardly
leeway1255883lee_way
legally1138133legally
legibly1344623legibly
lenity9612713l_enity
lentil64315393lentil_
lentils73912973lentils
leprosy1244223leprosy
levelly1335843levelly
levering122212503levering
levity1277903l_evity
lewdly1334393l_ewdly
liefly1266363lie_fly
lily76730183l___ily
livelily1444103livelily
loftily1336353loftily
logily1039833l_ogily
lonelily1144973lonelily
loonily1037073loonily
loopily1236803loopily
lordly1038753l_ordly
lousily1038333lousily
lovelily1444333lovelily
loverly1346973lover_ly
lowlily1335353lowlily
luckily16297083luckily
lumpily1476563lumpily
luridly1196283l_uridly
lustily103611243lustily
meatily12311093meatily
meekly1535193mee_kly
meetly1138673mee_tly
merely111312583_merely
messily12298813messily
metrify1535623metrify
nearly94813733near_ly
nervily1336863nervily
overfly16246883overfly
overly122411363over_ly
overply15227653overply
overtly13268983overtly
overwily1736663overwily
pearly116414843pear_ly
peartly1267453peartly
peerie83617893peeri_e
peeries93623023peeries
peering103520353peering
peery105719443peer__y
peppily1335123peppily
peril75425953_peril_
perils84121853_perils
perkily1637803perkily
pertly115312543_pertly
peskily1635083peskily
petrify1536573petrify
pettily1238173pettily
plenarily1444673plenarily
pleurisy1343663pleurisy
puerile9310093puerile
queerly1934233queer_ly
readily11711403readily
redrill857893redrill
reedify1465763reedify
reverify1744813reverify
scarily12311703scarily
seely84522633see__ly
seemly1138433see_mly
severely1445293severely
severity1446973severity
sexily1638853_sexily
sheerly13337703sheer_ly
sleazily2044103sleazily
sleekly14325183slee_kly
sorrily1039833sorrily
speedily1465173speedily
sterile7316603sterile
sternly1037853sternly
techily1537123techily
temerity1346903temerity
termly1138433_termly
terribly1344923terribly
terrify1336353terrify
testily102910803testily
veeries102916893veeries
veering113213683veering
veeringly1645473veeringly
veery115816253veer__y
verify153110163_verify
verity123714853_verity
warily122915093_warily
waterily1438783waterily
weekly1635313wee_kly
weevil1295433weevil_
weevilly1782623weevilly
weevils1384683weevils
weirdly14274493weirdly
wheezily2642303wheezily
wirily123310783_wirily
yearly125210273year_ly
zestily19167563zestily

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.1401276364.3
2DLD Change Limit1340271966.98319193.3
3Display Results1961960.0633111.1
 (SQL Overall)1786911967.18624866.5
 
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.