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 “cellaring” 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
cellaring123853(None) 
collaring12310561collaring
celling103921262cell__ing
clearing113014882c_learing
collaging1337932collaging
collating12312782collating
declaring1339572declaring
fellating1339252fellating
pillaring1237652pillaring
allaying12339313_allaying
alluring939073_alluring
ashlaring1344493ashlaring
bearing103624773be__aring
beggaring1435183beggaring
belaying143110603be_laying
beleaping1436743beleaping
belling103825073bell__ing
bellowing1547193bellowing
bellying14359073bell_ying
bewaring14279493be_waring
blaring104317113__blaring
blearing113111943_blearing
bullring11388423bull_ring
calling103826773call__ing
callusing1236173callusing
caring95137993c___aring
ceasing104118263ce__asing
ceiling103416723ceil__ing
cellar84514983cellar___
cellarage1243563cellarage
cellared11398793cellar_ed
cellarer10317923cellar_er
cellarers11236503cellarers
cellaret103713573cellar_et
cellarets11246063cellarets
cellars93713693cellar__s
cellarway1752193cellarway
censoring1238783censoring
censuring1237603censuring
centering122915143centering
centring112112953ce_ntring
cering94522533ce___ring
charing133721323c__haring
chelating1549363chelating
clawing133812673c__lawing
claying133614303c__laying
cleaning113112383c_leaning
clearings12286063c_learings
clearwing1533673c_learwing
cleating113518143c_leating
cleaving141389683c_leaving
cloaking15299713c_loaking
clouring112811273c_louring
coleading1338523coleading
collapsing1543833collapsing
colleting12311063colleting
colliding1338583colliding
colluding1335903colluding
collying14319553coll_ying
coloring11414843c_oloring
colouring1258733colouring
comparing162410583comparing
culling103921303cull__ing
cullying14297503cull_ying
culturing1236553culturing
declawing1636213declawing
deflating142610713deflating
deglazing2135133deglazing
delating103119603de_lating
delaying133210973de_laying
deleading1237773deleading
deleaving1436263deleaving
deplaning1338053deplaning
deploring1337853deploring
earing75235483_e__aring
elating83423083_e_lating
enlacing1148773_enlacing
enlarging1135803_enlarging
fearing113520033fe__aring
fellahin1444513fellahin_
felling113321133fell__ing
fellowing1655923fellowing
flaring114116803__flaring
fullering1336653fullering
gearing92818843ge__aring
gelating103015733ge_lating
gelling93219763gell__ing
glaring93714883__glaring
hearing113324163he__aring
helling114623223hell__ing
helloing12159123hell_oing
hollaing12167103holla_ing
hollering1337743hollering
jelling153516613jell__ing
jellying19306173jell_ying
melling102822623mell__ing
mellowing1545893mellowing
nearing83020333ne__aring
pellagrin1253263pellagrin_
pellagrins1353423pellagrins
pelleting1237953pelleting
peltering122011673peltering
pillaging1345573pillaging
pollarding1444243pollarding
rearing83128783re__aring
reflating132514713reflating
regearing112211413regearing
reglazing2046553reglazing
rehearing132211763rehearing
relacing112516043re_lacing
relating92725443re_lating
relaxing162612633re_laxing
relaying122515153re_laying
relearning1135283relearning
releasing10411013releasing
reloading1189883reloading
reloaning10710483reloaning
replacing142210163replacing
replating122217403replating
replaying15259603replaying
reslating102516993reslating
retearing102214253retearing
rewearing132310703rewearing
seafaring1345963seafaring
searing83330923se__aring
selling83225833sell__ing
tallaging1146503tallaging
tearing84021493te__aring
telfering1336253telfering
telling83321083tell__ing
tillering1037883tillering
veluring1237563ve_luring
wearing113318863we__aring
welling112920313well__ing
wellspring1642123wellspring
weltering13219493weltering
yelling113516703yell__ing
yellowing1655073yellowing

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.470380193.6
2DLD Change Limit1486411387.07621006.4
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.60923484.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.