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

147 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
blazered203506(None) 
beavered1437502beavered
blabbered13184592blabbered
blared95018242bla__red
blathered15168352blathered
blattered12198562blattered
blazed184314712blaz__ed
blazer174414022blazer__
blazers184811682blazer_s
blazoned2044312blazoned
brazened20134902brazened
clavered14187632clavered
lagered92311152_lagered
layered11259412_layered
slavered12188032slavered
altered83215733al_tered
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bared85144483b_a__red
barred95725793b_a_rred
bartered113113013bartered
battered113315053battered
belabored1443813belabored
bettered113011833bettered
bickered17108003bickered
bistered112913323bistered
bittered112711833bittered
blabbed11357813bla_bbed
blacked163613373bla_cked
blackened1845273blackened
bladed104717763bla__ded
blader93618583blader__
bladers104214683blader_s
blamed116017953bla__med
blamer104417143blamer__
blamers115314213blamer_s
blanched16308603blanched
blanked144011223bla_nked
blanketed1643913blanketed
blare75826233bla__re_
blares85021633bla__res
blarneyed1542153blarneyed
blasted104213473bla_sted
blatherer14176713blatherer
blatted104812713bla_tted
blawed124713893bla__wed
blaze165520833blaz__e_
blazes174817353blaz__es
blazoner1944133blazoner
bleared104211253bl_eared
bleareyed1571913bleareyed
bleed85019803bl__e_ed
bleeped12287273bl_eeped
blethered15165433blethered
blinkered1644413blinkered
blistered12167683blistered
blithered15156123blithered
bloodred1234083bloodred
blubbered13164113blubbered
blundered1335193blundered
blurred10427803bl_urred
blustered12157263blustered
bolstered1246083bolstered
bordered1248933bordered
bothered142110393bothered
bowered133113043b_owered
brazed184717083braz__ed
brazer174917533brazer__
brazers184513943brazer_s
brokered1536083brokered
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
buttered112712623buttered
capered123014043_capered
catered103117763_catered
clabbered16184753clabbered
clambered16146123clambered
clamored1336943clamored
clattered12178403clattered
clovered14187363clovered
cratered1149673cratered
diapered1238003diapered
elaterid948613elaterid
faltered122810983faltered
flared105317603fla__red
flattered13188623flattered
flavored1554573flavored
fleered11309503fl_eered
flowered1546013flowered
glaceed1136193glace_ed
glaciered1343863glaciered
glaired9387743gla_ired
glandered1236333glandered
glared84715193gla__red
glazed174711773glaz__ed
glazer164212263glazer__
glazers174410033glazer_s
glowered1345753glowered
haltered123112553haltered
havered144011453_havered
laagered1055853laagered
labeled102510563_labeled
labored102810243_labored
lackered15108673_lackered
laddered1136743_laddered
ladened979053_ladened
laired75216813_la_ired
lakebed1434783_lakebed
lapeled10258893_lapeled
lappered13288213_lappered
latened8711923_latened
laterad8310833_laterad
lathered121512323_lathered
laveered1235253_laveered
lawyered1534033_lawyered
lazaret16411783_lazaret
lazed154925843_laz__ed
lazied164610653_laz_ied
leered73816223_l_eered
levered114212303_levered
livered113111633_livered
lowered112711913_lowered
palavered1543923palavered
paltered113012483paltered
papered122513163_papered
plastered1288893plastered
quavered2144813quavered
razeed163710013_raze_ed
razored1736333_razored
sabered103213023_sabered
slabbered14165083slabbered
slandered1137473slandered
slathered13148533slathered
slaverer11196993slaverer
slivered12218103slivered
tabered103311593_tabered
tapered102612933_tapered
teazeled18194233teazeled
ulcered1037973ul_cered
wafered14288433_wafered
wagered12299333_wagered
watered113014953_watered
wavered142910433_wavered

Search took 9 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.1731032896.0
2DLD Change Limit1461621478.45317291.1
3Display Results1471470.1231195.1
 (SQL Overall)1786911478.74920424.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.