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
declared124875(None) 
declare10411231declare_
declarer1148071declarer
declares11611321declares
declawed1545931declawed
cellared11398802cellared
dealated103213602dealated
decare93919152dec_are_
decares102818532dec_ares
decayed14309332dec_ayed
deceased1247722deceased
deciare10710662deciare_
deciares11510632deciares
declaimed1544382declaimed
declarers1236422declarers
declassed1345002declassed
declined123910882declined
decolored1345672decolored
deflated133412302deflated
deglazed2034952deglazed
delated93722872de_lated
delayed123310762de_layed
deplaned1238662deplaned
deplored1237232deplored
dewclawed1941532dewclawed
undeclared1445042undeclared
ascared10399523asc_ared
ashlared1253933ashlared
becalmed1534813becalmed
becharmed1944663becharmed
beclamored1752153beclamored
beclasped1643753beclasped
becloaked1843743becloaked
beggared1334753beggared
belaced124112153be_laced
belated103520013be_lated
belayed133610083be_layed
beslaved1435023beslaved
bewared13310113be_wared
blared95018243__blared
cared86050093__c_ared
cellarer10317933cellarer
cellaret103713583cellaret
chared125423693__chared
claret84026573__claret
clawed125115073__clawed
clayed125013043__clayed
cleared103612463__cleared
collared113211143collared
dackered16116893dackered
dared75935013d___ared
deaired9411533de_aired
dealate83617843dealate_
dealates92716683dealates
deaned84620453de__aned
dearer74822803de__arer
deaved114916553de__aved
debarked16175833de_barked
debarred12165643debarred
debased113310583de_based
debated113916083de_bated
debeaked1634613debeaked
debeard1137353debear_d
debearded1443373debearded
decade104216163dec_ade_
decades113615513dec_ades
decamped1634973decamped
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
decocted1437693decocted
decoded123212393dec_oded
decollated14136283decollated
decoloured1443083decoloured
decorated13312213decorated
decoyed14358343dec_oyed
decreased1345463decreased
decree93117783dec__ree
decreed112710263dec_reed
decried112612863dec_ried
decupled1494993decupled
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
doctored1245623doctored
dogeared1145793dogeared
dullard936603dullar_d
eared65139503_e__ared
echard1249223_echar_d
elated74725823_e_lated
enclaved1456343enclaved
enlaced102410523_enlaced
enlarged1035423_enlarged
feared106320433fe__ared
fellated1239563fellated
flared105317603__flared
geared85317743ge__ared
gelated93615643ge_lated
glared84715203__glared
hectare1238473hectare_
hectares1338863hectares
hectored1436893hectored
lechered1437523lechered
lectured11127233lectured
melamed1249633me_lamed
neared75119813ne__ared
necklaced1842603necklaced
nectaried1245453nectaried
peculated142310853peculated
pillared11228093pillared
precleared1544123precleared
reared75930013re__ared
recalled11310803recalled
recaned102817203rec_aned
recharged1656333recharged
recharted1557563recharted
reclad9311873recla__d
recladded1443673recladded
reclaimed1435543reclaimed
reclame11411063reclame_
reclames12310893reclames
reclasped1444873reclasped
recleaned1236583recleaned
reclined113613603reclined
recoaled113111793recoaled
recoated113416793recoated
recolored1246863recolored
recrated112918613recrated
recurred1137093recurred
reflated123514293reflated
regeared1039433regeared
reglazed1935743reglazed
relaced103517213re_laced
related83327573re_lated
relaxed153312533re_laxed
relayed113212753re_layed
replaced133211403replaced
replated112817523replated
replayed14248633replayed
reslated93517523reslated
scared95227293_sc_ared
seared75232843se__ared
secluded1233663secluded
sectored1138083sectored
secured1059723sec_ured
teared75722153te__ared
unclawed1457983unclawed
uncleared1237543uncleared
vectored1435643vectored
velured1136683ve_lured

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.406440125.6
2DLD Change Limit1461622317.61019206.6
3Display Results2312310.0932483.9
 (SQL Overall)1786912318.10922036.1
 
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.