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

231 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
declared124874(None) 
declare10411221declare_
declarer1148061declarer
declares11611311declares
declawed1545921declawed
cellared11398792cellared
dealated103213602dealated
decare93919152dec_are_
decares102818532dec_ares
decayed14309332dec_ayed
deceased1247712deceased
deciare10710662deciare_
deciares11510632deciares
declaimed1544382declaimed
declarers1236422declarers
declassed1344992declassed
declined123910882declined
decolored1345662decolored
deflated133412302deflated
deglazed2034952deglazed
delated93722872de_lated
delayed123310762de_layed
deplaned1238662deplaned
deplored1237232deplored
dewclawed1941532dewclawed
undeclared1445042undeclared
ascared10399523asc_ared
ashlared1253933ashlared
becalmed1534813becalmed
becharmed1944663becharmed
beclamored1752143beclamored
beclasped1643743beclasped
becloaked1843733becloaked
beggared1334753beggared
belaced124112153be_laced
belated103520013be_lated
belayed133610083be_layed
beslaved1435023beslaved
bewared13310113be_wared
blared95018243__blared
cared86050093__c_ared
cellarer10317923cellarer
cellaret103713573cellaret
chared125423693__chared
claret84026573__claret
clawed125115073__clawed
clayed125013043__clayed
cleared103612463__cleared
collared113211143collared
dackered16116893dackered
dared75935013d___ared
deaired9411533de_aired
dealate83617843dealate_
dealates92716683dealates
deaned84620453de__aned
dearer74822803de__arer
deaved114916553de__aved
debarked16175823de_barked
debarred12165633debarred
debased113310583de_based
debated113916083de_bated
debeaked1634613debeaked
debeard1137353debear_d
debearded1443373debearded
decade104216163dec_ade_
decades113615513dec_ades
decamped1634963decamped
decane93818873dec_ane_
decanes103118913dec_anes
decanted122310493decanted
decapod1335433dec_apod
decayer13339353dec_ayer
decease1049523decease_
deceases11410153deceases
deceived1535893deceived
decentred13236233decentred
decerned1237263decerned
decided124312423dec_ided
decimated1548953decimated
decked145217623dec__ked
declaim1247363decla_im
declaimer1444233declaimer
declaims1345823declaims
declarant1246033declarant
declaring1339573declaring
declass1038733decla_ss
declasse1165943declasse
declasses1246443declasses
declaw1266703decla__w
declaws1336253decla_ws
decline103716613decline_
decliner113710843decliner
declines113315803declines
decocted1437683decocted
decoded123212383dec_oded
decollated14136283decollated
decoloured1443083decoloured
decorated13312203decorated
decoyed14358333dec_oyed
decreased1345453decreased
decree93117783dec__ree
decreed112710253dec_reed
decried112612853dec_ried
decupled1494983decupled
decurved1534843decurved
deejayed2042443deejayed
defaced142910973de_faced
defamed14309833de_famed
defeated132812163defeated
deferred13106363deferred
defiladed15143473defiladed
deflate113613943deflate_
deflater123211603deflater
deflates123013943deflates
defleaed1344953defleaed
deflexed2043883deflexed
defoamed15356243defoamed
defrayed1635403defrayed
deglaze1835583deglaze_
deglazes1935463deglazes
degraded12288323degraded
dekare112811563de_kare_
dekares122710873de_kares
delate73827753de_late_
delates83526283de_lates
delayer113010533de_layer
deleaded1148333deleaded
deleaved1346573deleaved
deled75326543de_l__ed
deleted93314913de_leted
delimed11310723de_limed
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demarked16187223de_marked
demeaned1237283demeaned
demurred1234933demurred
dentated10411703dentated
departed1238823de_parted
depilated1339653depilated
deplane10311413deplane_
deplanes11311213deplanes
depleted12258723depleted
deplore1039483deplore_
deplorer1136343deplorer
deplores1139533deplores
deployed1535913deployed
deplumed1434083deplumed
depraved1535543depraved
derated93623503de_rated
desalted1038313desalted
desired9311983de_sired
desolated1139653desolated
despaired1344503despaired
desugared1242663desugared
deterred10137803deterred
detoured1036513detoured
devalued1335013devalued
deviated13311043deviated
devoured1335723devoured
dewaxed19316053de_waxed
dewlapped1841953dewlapped
dickered16117533dickered
dictated1239203dictated
dilated93115823d_ilated
doctored1245613doctored
dogeared1145793dogeared
dullard936603dullar_d
eared65139503_e__ared
echard1249223_echar_d
elated74725823_e_lated
enclaved1456343enclaved
enlaced102410523_enlaced
enlarged1035413_enlarged
feared106320433fe__ared
fellated1239563fellated
flared105317603__flared
geared85317743ge__ared
gelated93615633ge_lated
glared84715193__glared
hectare1238463hectare_
hectares1338853hectares
hectored1436873hectored
lechered1437523lechered
lectured11127223lectured
melamed1249633me_lamed
neared75119803ne__ared
necklaced1842593necklaced
nectaried1245443nectaried
peculated142310853peculated
pillared11228093pillared
precleared1544113precleared
reared75930013re__ared
recalled11310803recalled
recaned102817203rec_aned
recharged1656333recharged
recharted1557563recharted
reclad9311873recla__d
recladded1443673recladded
reclaimed1435543reclaimed
reclame11411063reclame_
reclames12310893reclames
reclasped1444863reclasped
recleaned1236583recleaned
reclined113613603reclined
recoaled113111783recoaled
recoated113416783recoated
recolored1246853recolored
recrated112918603recrated
recurred1137093recurred
reflated123514293reflated
regeared1039433regeared
reglazed1935743reglazed
relaced103517213re_laced
related83327573re_lated
relaxed153312533re_laxed
relayed113212753re_layed
replaced133211403replaced
replated112817523replated
replayed14248633replayed
reslated93517523reslated
scared95227293_sc_ared
seared75232843se__ared
secluded1233663secluded
sectored1138063sectored
secured1059723sec_ured
teared75722153te__ared
unclawed1457983unclawed
uncleared1237543uncleared
vectored1435623vectored
velured1136683ve_lured

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.453394461.4
2DLD Change Limit1461622317.40619735.6
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.95222471.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.