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

166 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
blennies105693(None) 
bennies93917311b_ennies
beanies93821092b_eanies
bennes86019012b_enn_es
bennis84314802b_enni_s
blenches153310762blenches
blendes104713682ble_ndes
bunnies94415002b_unnies
jennies143511622_jennies
pennies94218812_pennies
plenties10314692plenties
tennies73017972_tennies
abhenries1444503abhenries
adenines9310193adenines
agencies1138743agencies
alanines8314803alanines
alexines15258503alexines
balconies1347743balconies
bandies104124863b_andies
banties94324763b_anties
baronies10315023baronies
beanie83618593b_eanie_
beedies10314203b_eedies
beelines103312803beelines
beladies11310423beladies
belemnites1443573belemnites
belfries1336983belfries
belies84631053b_e_lies
bellies94023723b_ellies
benames112814603b_enames
benches143918603b_enches
bendees103913863b_endees
bendier103111413b_endier
bendiest112311983b_endiest
benes75536233b_e_n_es
benne76521123b_enn_e_
bennet84823363b_enn_et
bennets94712163b_ennets
benni74715363b_enni__
benzines1938213b_enzines
benzins1838693b_enzins
berries94423553b_erries
betonies10413063betonies
bevies114017303b_e_vies
biennales1143803biennales
biennia994933bienni_a
biennial1065093biennial
biennials1183633biennials
biennium1263433biennium
bienniums1352723bienniums
blanches153311603blanches
blasties102113633blasties
bleaches153410673bleaches
blearier1037333blearier
bleariest1158843bleariest
blenched16358053blenched
blencher15308393blencher
blenchers16356723blenchers
blende95413443ble_nde_
blended114710713ble_nded
blender104613843ble_nder
blenders115210993blenders
blending12249963blending
blends96012883ble_n_ds
blennioid1281663blennioid
blenny1156203blenn__y
blesses93812393ble_sses
blinis85313683bl_ini_s
blintzes1944263blintzes
blondes104213163bl_ondes
blondines1246153blondines
bloodies11310163bloodies
bluelines1145833bluelines
bluenoses1144223bluenoses
blunges104212223bl_unges
bonnes85621453b_onn_es
bonnie85314853b_onnie_
bonnier94711313b_onnier
bonniest10310773b_onniest
boonies93422483b_oonies
botanies10312853botanies
bounties10311403bounties
brandies11714563brandies
brannier10218933brannier
branniest11199383branniest
brinies93317913b_rinies
brionies10310543brionies
brownies13189613brownies
bryonies1336843bryonies
burnies94017823b_urnies
byrnies12378573b_yrnies
cleanses10358143cleanses
clenches152910953clenches
clergies1137903clergies
crannies10313013crannies
denies74729643_de_nies
elegies81312903ele_gies
envies9314053__envies
fannies103415643_fannies
felonies11310993felonies
fennier10339253_fennier
fenniest113113203_fenniest
flenches163410533flenches
flenses1039473fle_nses
fluencies1445933fluencies
flunkies1536393flunkies
frenzies2037713frenzies
funnies104113603_funnies
genies75324943_ge_nies
grannies9312613grannies
greenies9312673greenies
gunnies83413123_gunnies
heinies102514543_heinies
henries102718283_henries
hinnies103615103_hinnies
johnnies1872993johnnies
lefties10312073_lefties
lenes54738523_le_n_es
lenis56326863_le_ni_s
lenites7818443_lenites
lenities8315943_lenities
lenses64620893_le_nses
lentils73912973_lentils
leones64417723_leon_es
levies93919863_le_vies
lezzies1536203_lezzies
lindies8416583_lindies
longies82916553_longies
loonies73919543_loonies
lunies64723013_l_unies
meanies93620743_meanies
meinies92516073_meinies
minnies93617363_minnies
nannies73015203_nannies
ninnies73713613_ninnies
olefines1137323olefines
oleines7313393olein_es
pennines103112043_pennines
pennis84315743_penni_s
peonies93620153_peonies
pfennigs1461983pfennigs
pinnies93318443_pinnies
plenaries11410383plenaries
plenches153110623plenches
rennins74013413_rennins
sennits73811283_sennits
shannies113411253shannies
sheenies111411543sheenies
shinnies113010913shinnies
sonnies7315223_sonnies
spinnies103210543spinnies
sweenies11148763sweenies
tennis64015303_tenni_s
tennises82810133_tennises
trannies8415013trannies
trendies9312213trendies
tunnies73614263_tunnies
tweenies11146393tweenies
twenties1137503twenties
valencies1446413valencies
venines103516613_venines
weenies102915093_weenies
wennier10318603_wennier
wenniest11259593_wenniest
whinnies14237273whinnies
wienies102213683wie_nies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621666.57622226.6
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.06225303.2
 
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.