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

138 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
blathered1516835(None) 
blatherer14176711blatherer
blattered12198561blattered
blethered15165431blethered
blithered15156121blithered
lathered121512321_lathered
slathered13148541slathered
battered113315052b_attered
blabbered13184592blabbered
blather125314202blather__
blatherers15175342blatherers
blathers134713792blather_s
blazered2035062bla_zered
bothered142110392b_othered
brothered1546002brothered
clattered12178402clattered
fathered151510432_fathered
feathered16188892feathered
flattered13188622flattered
gathered13149372_gathered
heathered16149462heathered
latherer111310442_latherer
leathered13148712leathered
slithered13136622slithered
weathered16168512weathered
adhered1239233__adhered
altered83215733al_t_ered
badgered1336213b_adgered
bannered11299323b_annered
bantered113313633b_antered
barbered13259543b_arbered
bartered113113013b_artered
bathed125518743b_ath__ed
bather115322513b_ather__
bathers124720363b_ather_s
battened11259573b_attened
batterer102713213b_atterer
beavered1437503bea_vered
betattered1343143betattered
bettered113011833b_ettered
bistered112913323bist_ered
bittered112711833b_ittered
blackened1845273blackened
blanketed1643913blanketed
blared95018243bla___red
blarneyed1542153blarneyed
blasphemed2051973blasphemed
blathering16107583blathering
blatted104812713blat__ted
blatter94415653blatter__
blatters104414093blatter_s
blether12459913blether__
blethers13429613blether_s
blinkered1644413blinkered
blistered12167683blistered
blither124812173blither__
blithers134711233blither_s
blubbered13164113blubbered
blundered1335193blundered
blustered12157263blustered
bolstered1246093bolst_ered
burthened1543963burthened
butchered1744583butchered
buttered112712623b_uttered
catered103117773_cat_ered
chattered15197993chattered
clabbered16184763clabbered
clambered16146133clambered
clatterer11186983clatterer
clavered14187633cla_vered
cluttered12185943cluttered
cratered1149683crat_ered
dithered13189293_dithered
elaterid948613elat_erid
faltered122810983falt_ered
featherbed19174663featherbed
flathead1535803flathe_ad
flattened13185303flattened
flatterer12187673flatterer
flittered13196253flittered
fluttered13185943fluttered
furthered1644473furthered
gatherer12147903_gatherer
glaciered1343863glaciered
glandered1236333glandered
glittered11195403glittered
goatherd1335263goather_d
haltered123112553halt_ered
ingathered1542963ingathered
kashered1636403_kashered
laagered1055853_laagered
lackered15108673_lackered
laddered1136743_laddered
lagered92311153_la_gered
lappered13288213_lappered
latened8711923_lat_ened
laterad8310843_lat_erad
lathed104718453_lath__ed
lather95124353_lather__
latherers12158853_latherers
lathers104321883_lather_s
lathery133911123_lather_y
laveered1235253_laveered
lawyered1534033_lawyered
layered11259413_la_yered
lechered1437523_lechered
lettered92910783_lettered
littered92511383_littered
mattered112412903_mattered
mothered142310103_mothered
murthered1544473murthered
nattered92011623_nattered
neatherd12107193neather_d
paltered113012483palt_ered
pattered112714203_pattered
plastered1288893plastered
pothered142311043_pothered
regathered15124573regathered
scattered12197353scattered
shattered13178203shattered
slabbered14165083slabbered
slandered1137473slandered
slather103816073slather__
slathers113914783slather_s
slavered12188033sla_vered
smattered12186783smattered
smothered1545683smothered
spattered12187643spattered
splattered13163933splattered
swithered16135463swithered
tattered92011443_tattered
tethered1238493_tethered
unfathered1743783unfathered
upgathered1742023upgathered
watered113014953_wat_ered
withered15169433_withered
wuthered15157433_wuthered
yattered12239533_yattered

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411386.87621617.4
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.35824285.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.