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

169 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
cellared1139880(None) 
cellarer10317931cellarer
cellaret103713581cellaret
collared113211141collared
cellae84915932cella_e_
cellar84514982cellar__
cellarers11236502cellarers
cellarets11246062cellarets
cellars93713692cellar_s
celled94420322cell__ed
cleared103612462c_leared
collaged12279972collaged
collard103712922collar_d
collaret103116702collaret
collated113615062collated
declared1248752declared
fellated1239562fellated
ocellated1245452ocellated
pillared11228092pillared
allayed11138063_allayed
allured8299173_allured
ashlared1253933ashlared
beggared1334753beggared
belaced124112153be_laced
belated103520013be_lated
belayed133610083be_layed
beleaped1336103beleaped
belled94626193bell__ed
bellied104314073bell_ied
bellowed14158613bellowed
beslaved1435023beslaved
bewared13310113be_wared
blared95018243__blared
bleared104211253_bleared
bollard103210503bollar_d
calibred1335053calibred
called94126733call__ed
callused1135853callused
cared86050093c___ared
ceased94920783ce__ased
ceiled94114953ceil__ed
cella75420313cella___
cellarage1243573cellarage
cellarages1343473cellarages
cellarette1252493cellarette
cellaring1238533cellaring
cellarway1752203cellarway
cellmate1237873cellmate_
cellmates1347513cellmates
cellule936523cellule_
cellules1036813cellules
censored11197953censored
censured11248913censured
centare93113703centare_
centares102913893centares
centered112513523centered
centred103411683ce_ntred
cerated103922473ce_rated
cered85227443ce___red
chared125423693c__hared
chelated142610493chelated
ciliated11510953ciliated
claret84026573c__laret
clawed125115073c__lawed
clayed125013043c__layed
cleaned103512003c_leaned
clearer93710823c_learer
cleated103417843c_leated
cleaved134010483c_leaved
cloaked14368543c_loaked
cloured103111543c_loured
collage102813763collage_
collagen11338583collagen
collages113514243collages
collapsed1443223collapsed
collar83816173collar__
collards113310193collards
collarets11327333collarets
collars93816573collar_s
collate92919683collate_
collates103019143collates
colleted113011663colleted
collided12309803collided
collied103316683coll_ied
colluded12296463colluded
colored10313473c_olored
coloured1148313coloured
compared153811823compared
culled94022473cull__ed
cullied104012353cull_ied
cultured1137233cultured
dealated103213603dealated
declare10411233declare_
declarer1148073declarer
declares11611323declares
declawed1545933declawed
deflated133412303deflated
deglazed2034953deglazed
delated93722873de_lated
delayed123310763de_layed
deleaded1148333deleaded
deleaved1346573deleaved
deplaned1238663deplaned
deplored1237233deplored
dullard936603dullar_d
eared65139503_e__ared
elated74725823_e_lated
enlaced102410523_enlaced
enlarged1035423_enlarged
feared106320433fe__ared
fellate10313433fellate_
fellates11312753fellates
felled103720303fell__ed
fellowed15136843fellowed
flared105317603__flared
fullered1236383fullered
geared85317743ge__ared
gelated93615643ge_lated
gelled84718893gell__ed
glared84715203__glared
helled104024703hell__ed
helloed113512433hell_oed
hollaed11359853holla_ed
hollered1237603hollered
jelled144916063jell__ed
jellied15419223jell_ied
mallard10310273mallar_d
melamed1249633me_lamed
melled95023023mell__ed
mellowed14166933mellowed
neared75119813ne__ared
ocellar936533ocellar__
ocellate1037873ocellate_
pelleted1138203pelleted
peltered112510453peltered
pillaged12298093pillaged
pollard103511143pollar_d
pollarded1344703pollarded
reared75930013re__ared
reflated123514293reflated
regeared1039433regeared
reglazed1935743reglazed
relaced103517213re_laced
related83327573re_lated
relaxed153312533re_laxed
relayed113212753re_layed
relearned1035643relearned
released9310243released
reloaded1059103reloaded
reloaned939723reloaned
replaced133211403replaced
replated112817523replated
replayed14248633replayed
reslated93517523reslated
seared75232843se__ared
selvaged1334343selvaged
stellated1046803stellated
tallaged10257923tallaged
teared75722153te__ared
telfered1234883telfered
tillered937443tillered
ullaged937033_ullaged
velured1136683ve_lured
welfare1335723welfare_
welfares1445553welfares
welled103820213well__ed
weltered12238443weltered
yelled104116253yell__ed
yellowed15185753yellowed

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.420425454.8
2DLD Change Limit1461621697.73618893.7
3Display Results1691690.0632682.5
 (SQL Overall)1786911698.21921741.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.