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

266 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
centering12291514(None) 
cantering122417371cantering
centerings13247661centerings
centring112112951cent_ring
entering91920051_entering
tentering102313201tentering
bantering122414232bantering
bettering122212752bettering
cankering162110792cankering
catering112019902c_atering
censoring1238782censoring
censuring1237602censuring
centerline1247042centerline
centrings12227602cent_rings
chuntering1647802chuntering
cindering13311222cindering
countering13314472countering
cratering12312652cratering
decentering1546482decentering
festering132413172festering
fettering132310512fettering
gendering12249752gendering
gettering112310032gettering
lettering102112072lettering
mentoring1239542mentoring
metering112915632me_tering
neutering1038962neutering
peltering122011672peltering
pestering122315662pestering
petering112516812pe_tering
reentering1149982reentering
rendering112213182rendering
sceptering1545792sceptering
sintering101014802sintering
teetering10239892teetering
tendering112210812tendering
veneering1337662veneering
venturing1337552venturing
weltering13219492weltering
westering132112642westering
wintering13412362wintering
altering91917113_altering
angering102113803_angering
anteing8312813_ante_ing
bannering12208803bannering
bartering122313643bartering
battering122715143battering
beavering1538703beavering
bittering122511993bittering
bunkering16207103bunkering
buttering122312523buttering
calendering1543473calendering
cambering16109873cambering
canceling14310163canceling
canoeing11310213canoe_ing
canting104725903cant__ing
cantoning12310883cantoning
capering132414963c_apering
capturing1436623capturing
careering12311203careering
carpentering1753013carpentering
cellaring1238523cellaring
censing104215263cen__sing
censusing1244813censusing
center84421413center___
centered112513523center_ed
centerlines1346993centerlines
centers94420603center__s
centesimi1352323centesimi
centesimo1352813centesimo
centesis1058143centesi_s
centric11312403cent_ri_c
centrism1249643cent_rism
centrist10314863cent_rist
centupling1543013centupling
centurial1147953centurial
centuries11311333centuries
centurion1165883centurion
centurions1255513centurions
cering94522533c___ering
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
checkering2244403checkering
cheering143612703c_heering
chequering2543123chequering
chittering16107183chittering
cincturing1554263cincturing
cinerin9313823cin_erin_
cinerins10414103cin_erins
ciphering17217703ciphering
clattering13109233clattering
clavering1538373clavering
clinkering1745233clinkering
cloturing1245473cloturing
clustering13116813clustering
cluttering13106833cluttering
cockering1839693cockering
coenduring1444233coenduring
coffering1838043coffering
cohering142413833c_ohering
coinhering1647313coinhering
cointerring1447143cointerring
compering163414163compering
conceding1559343conceding
concentering1755433concentering
concerning1548903concerning
concerting15313893concerting
conferring1648743conferring
congeeing1337903congeeing
conjuring1937913conjuring
conquering2246273conquering
conserving1639753conserving
contemning1577063contemning
contending1449123contending
contenting13313323contenting
contesting13312213contesting
contorting13410103contorting
contouring1347013contouring
contusing1239143contusing
convening15311193convening
converging1758093converging
conversing16310543conversing
converting16313133converting
conveying1838323conveying
coopering142611323coopering
coppering162810893coppering
cornering12311893cornering
coshering15510023coshering
covering142215723c_overing
cowering142514033c_owering
craterings1346003craterings
creneling1247733cren_eling
culturing1236553culturing
cumbering16108203cumbering
cyphering20175243cyphering
dandering122511063dandering
dangering12239303dangering
decentring1446753decent_ring
denaturing12115853denaturing
denting94422183dent__ing
deterging1237853de_terging
deterring1138623de_terring
dewatering1545773dewatering
encoring11312173_encoring
endearing1139323_endearing
enduring10310013_enduring
enserfing1345893_enserfing
ensuring9310173_ensuring
enteric9314213_enteri_c
enterics10312853_enterics
enteron7313333_enteron_
enterons8314153_enterons
enticing11311803_enticing
enuring8813883_en_uring
faltering132211113faltering
feathering17108793feathering
featuring1337323featuring
fevering152510083fe_vering
filtering13199723filtering
fingering1439193fingering
fostering132411263fostering
gandering122111293gandering
gartering112111573gartering
gentling1048453gent_ling
gesturing1136653gesturing
gingering1238873gingering
guttering112410443guttering
haltering132212003haltering
hankering17239383hankering
hectoring1538303hectoring
henting113719653hent__ing
hindering14310273hindering
hungering14187683hungering
hunkering17227123hunkering
inhering12913713_inhering
interning10315253_interning
interring10315423_interring
jeering153513043je__ering
jittering17218423jittering
kenneling1464083kenneling
leathering1488683leathering
lechering1538443lechering
lecturing1237303lecturing
leering83417643le__ering
leistering1147983leistering
letterings11226003letterings
levering122212503le_vering
lingering11310513lingering
littering102411983littering
loitering1039683loitering
lustering102711203lustering
mastering122315303mastering
mattering122314053mattering
meandering1446983meandering
metring103215293me_t_ring
misentering1446373misentering
mitering113015403_mitering
mongering13310353mongering
mustering122212333mustering
muttering122611323muttering
nattering102212213nattering
neatening1038353neatening
oystering1337563oystering
paltering122612893paltering
pandering133211963pandering
pattering122314423pattering
peering103520353pe__ering
peppering1337083peppering
pondering132411333pondering
portering122012303portering
pottering122612003pottering
puttering122611643puttering
realtering1139473realtering
reinterring1245363reinterring
renaturing11176803renaturing
renderings12256083renderings
reneging102111533ren_eging
renewing121910713ren_ewing
renting84026853rent__ing
restoring10314613restoring
restring91518783rest_ring
retearing102214253re_tearing
retiring92717413re_tiring
reuttering1137573reuttering
revering122918073re_vering
sauntering1137223sauntering
scattering1398013scattering
scenting113212813scent__ing
sceptring1444273scept_ring
scunnering1344133scunnering
scuttering1386633scuttering
sectoring1239583sectoring
sentencing1345403sentencing
severing122013853se_vering
sewering122411093se_wering
sheltering1446493sheltering
sistering101213753sistering
skeltering1545003skeltering
sneering93414503_sneering
sundering11312323sundering
sweltering1445233sweltering
tattering102212323tattering
teddering12256303teddering
telfering1336253telfering
tempering1438733tempering
tenting84621153tent__ing
tenuring938863ten_uring
tethering1339133tethering
texturing1735223texturing
tinkering1437703tinkering
tittering102310313tittering
tottering10229613tottering
untiring9312003_untiring
uttering91613083_uttering
vectoring1537413vectoring
veering113213683ve__ering
veneerings1443583veneerings
venting114218093vent__ing
vesturing1337203vesturing
waitering13310713waitering
wandering143310983wandering
watering122316313_watering
weathering1798353weathering
wondering142110463wondering
yattering132410443yattering

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412667.90618801.0
3Display Results2662660.1102418.2
 (SQL Overall)1786912668.43921174.4
 
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.