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

386 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
centring11211295(None) 
centering122915141centering
centrings12227601centrings
cantering122417372cantering
canting104725902cant_ing
censing104215262cen_sing
censoring1238782censoring
censuring1237602censuring
centerings13247662centerings
centric11312402centri_c
centrism1249642centrism
centrist10314862centrist
cering94522532ce__ring
decentring1446752decentring
denting94422182dent_ing
entering91920052_entering
enuring8813882_enuring
gentling1048452gentling
henting113719652hent_ing
mentoring1239542mentoring
metring103215292me_tring
renting84026852rent_ing
restring91518782restring
scenting113212812scent_ing
sceptring1444272sceptring
tentering102313202tentering
tenting84621152tent_ing
tenuring938862tenuring
venting114218092vent_ing
venturing1337552venturing
accenting1487823accent_ing
acentric1247533acentri_c
agenting1039383agent_ing
anearing9413973anearing
anteing8312813_anteing
anting75827023_ant_ing
bantering122414233bantering
bantling112612003bantling
bearing103624773be_aring
beating104326873beat_ing
beetling1139283beetling
belting104119133belt_ing
bemiring13239603bemiring
benaming1339693benaming
benching163411343benching
bending114420893ben_ding
berthing14209593berthing
besting104923923best_ing
bettering122212753bettering
betting103921403be_tting
bewaring14279493bewaring
bunting103718833bunt_ing
canaling112016413canaling
candling122313873candling
candying15188993candying
caning94128623can__ing
cankering162110793cankering
canning103620133can_ning
canoeing11310213canoeing
cantina93417253cant_ina
cantoning12310883cantoning
cantrip112910043cantri_p
cantrips12318933cantrips
capering132414963capering
capturing1436623capturing
caring95137993c__aring
carting104228283cart_ing
casting104628343cast_ing
castling11311233castling
catering112019903catering
catling104819793c_atling
catting103922643c_atting
ceasing104118263ce_asing
ceding104014803ce__ding
ceiling103416723ce_iling
cellaring1238523cellaring
celling103921263ce_lling
cementing1438763cement_ing
censusing1244813censusing
centai84814783centai__
centerline1247043centerline
centile94217183cent_ile
centime114513033cent_ime
centimo11609543cent_imo
centra84113883centr__a
central93114473centr_al
centrals102712033centrals
centre84316643centr__e
centred103411683centr_ed
centres93817123centr_es
centrical1348353centrical
centrifuge1652813centrifuge
centriole1145673centriole
centrisms1348053centrisms
centrists11410233centrists
centroid1159313centroid
centroids1247043centroids
centrum1168603centr_um
centrums1236913centrums
centupling1543013centupling
centurial1147953centurial
centuries11311333centuries
centurion1165883centurion
centurions1255513centurions
certain92612213certain_
cessing103814813ce_ssing
chairing143110773chairing
chanting143413533chant_ing
charing133721323c_haring
charring142913163charring
charting142614193charting
chatting142810143chatting
cheating144014523cheat_ing
cheering143612703cheering
chirring142610173chirring
chitling142910663chitling
choiring14279793choiring
choring133617663c_horing
chuntering1647803chuntering
churring14298653churring
chuting132910733chut_ing
cinching163310223cinching
cincturing1554263cincturing
cindering13311223cindering
cinerin9313823cinerin_
cinerins10414103cinerins
citing94220183c_it_ing
citrin82615413c_itrin_
citrine92514023c_itrine
citrins92614363c_itrins
clearing113014883clearing
cleating113518133cleat_ing
clefting14347583cleft_ing
clenching17266303clenching
clothing14278783clothing
clotting113110643clotting
cloturing1245473cloturing
clouring112811273clouring
coating103525313coat_ing
coenduring1444233coenduring
cohering142413833cohering
coloring11414843coloring
congaing1239823congaing
coning94331823con__ing
conjuring1937913conjuring
conking143618453con_king
conning103718753con_ning
constringe1345853constringe
construing1347443construing
contain9315833contain_
contains10316533contains
contorting13410103contorting
contouring1347013contouring
contrite10318543contrite
contrive13311353contrive
contriving1648193contriving
contusing1239143contusing
coring94433963c__oring
cornering12311893cornering
costing104323023cost_ing
coting94629253c_ot_ing
countering13314473countering
counting113115273count_ing
courting112514573courting
covering142215723covering
cowering142514033cowering
cratering12312653cratering
crating103725203crat_ing
creating113921953creat_ing
creneling1247733creneling
cresting114017043crest_ing
culturing1236553culturing
cunning104214623cun_ning
curing94824783c__uring
curring103616843c_urring
cutting103817493c_utting
cuttling1138203cuttling
deairing10311893deairing
decentering1546483decentering
denaturing12115853denaturing
denning93515173den_ning
denoting10311753denoting
dentin73919573dent_in_
dentine83320243dent_ine
dentins83419223dent_ins
denuding1137113denuding
denying123711293den_ying
desiring10312143desiring
dextrin1587543dextrin_
dextrine1688253dextrine
dextrins16117823dextrins
dinting93520553dint_ing
dunting93418383dunt_ing
earing75235483_e_aring
earring83519013_earring
eating75134403_eat_ing
encoring11312173_encoring
ending83220253_en_ding
endrin7312403_endrin_
endrins8312163_endrins
enduing9249723_enduing
enduring10310013_enduring
ensuing8239543_ensuing
ensuring9310173_ensuring
enticing11311803_enticing
entrain7313073_entrain_
entrains8312963_entrains
entrant7318873_entrant
entries71523163_entries
entwine1039143_entwine
envying1435713_envying
erring73816483_e_rring
estrin6315923_estrin_
estrins7315853_estrins
fearing113520033fe_aring
featuring1337323featuring
feinting123410833feint_ing
felting113515213felt_ing
fencing132411133fen_cing
fending123717603fen_ding
festering132413173festering
feting104417793fe_t_ing
fettering132310513fettering
fetting113517873fe_tting
fettling1266773fettling
fevering152510083fevering
gearing92818843ge_aring
gendering12249753gendering
gentrice1148813gentrice
gentries91315263gentries
gentrify1544683gentrify
gesturing1136653gesturing
gettering112310033gettering
getting93316563ge_tting
hanting114124483hant_ing
hearing113324163he_aring
hearting12513123hearting
heating114024323heat_ing
hectoring1538303hectoring
hefting144510913heft_ing
heiring113312903he_iring
hennaing1234993hennaing
herring113615883he_rring
hinting113919223hint_ing
honoring12310473honoring
hunting114317123hunt_ing
ignoring1036483ignoring
incenting12912063incent_ing
inuring81213013_inuring
jeering153513043je_ering
jesting154317713jest_ing
jetting153815343je_tting
jettying1933953jettying
kenning124010543ken_ning
lecturing1237303lecturing
leering83417643le_ering
leftwing1532973leftwing
lending94118533len_ding
leniting9312353leniting
lensing84015103len_sing
lettering102112073lettering
letting83218533le_tting
levering122212503levering
linting83820983lint_ing
lunting83817743lunt_ing
lustring9269723lustring
mantling112012613mantling
manuring1139223manuring
meeting103314963meet_ing
melting103317753melt_ing
menacing1339783menacing
mending114018683men_ding
mensing103915103men_sing
metering112915633metering
meting94320593me_t_ing
minoring11311473minoring
minting103020813mint_ing
mitring103514143_mitring
munting103718773munt_ing
nearing83020333ne_aring
nesting84320443nest_ing
nestling958893nestling
netting84018763ne_tting
nettling957213nettling
neutering1038963neutering
neutrino845223neutrino
oestrin7312243oestrin_
oestrins8312673oestrins
outring84021023_outring
panting104025423pant_ing
peering103520353pe_ering
peltering122011673peltering
pelting102917273pelt_ing
pending114119773pen_ding
penning103616493pen_ning
pestering122315663pestering
pestling111010253pestling
petering112516813petering
petting103720953pe_tting
pettling1168213pettling
punting103318443punt_ing
ranting84025413rant_ing
rearing83128783re_aring
reboring11312783reboring
reentering1149983reentering
refiring123513923refiring
rehiring122911883rehiring
renaming11313693renaming
renaturing11176803renaturing
rendering112213183rendering
rending93924263ren_ding
reneging102111533reneging
renewing121910713renewing
respring111614063respring
resting85031183rest_ing
restoring10314613restoring
restrings10159293restrings
restrung9176443restrung
retiring92717413retiring
retrying122410453re_trying
retting83425883re_tting
retying113213833re_tying
revering122918073revering
rewiring122911223rewiring
scanting113914763scant_ing
scantling12107233scantling
scending122610583scen_ding
sceptering1545793sceptering
searing83330923se_aring
seating84130683seat_ing
sectoring1239583sectoring
securing11310413securing
seething1239023seething
sending94221373sen_ding
sensing84116953sen_sing
sentries81318053sentries
sering74731813se__ring
setting83621393se_tting
settling978943settling
severing122013853severing
sewering122411093sewering
sintering101014803sintering
snaring83920953_snaring
sneering93414503sneering
snoring83917203_snoring
string75327563__string
tearing84021493te_aring
teetering10239893teetering
teething1237163teething
tendering112210813tendering
tending94419163ten_ding
tenoning938893tenoning
tensing84616653ten_sing
testing86021053test_ing
texturing1735223texturing
tinting84620603tint_ing
unerring9311273unerring
unstring9312093unstring
untiring9312003_untiring
untying1138943_untying
vectoring1537413vectoring
veering113213683ve_ering
veluring1237563veluring
vending124015263ven_ding
veneering1337663veneering
venging123710943ven_ging
venoming1436403venoming
vesting114618683vest_ing
vesturing1337203vesturing
vetoing11309053ve_toing
vetting114216563ve_tting
wanting114220173want_ing
wearing113318863we_aring
weeting113816053weet_ing
weltering13219493weltering
welting113615313welt_ing
wenching17328863wenching
wending123816843wen_ding
westering132112643westering
westing115020273west_ing
wetting114117383we_tting
wintering13412363wintering
wintling12249923wintling
wonting113214103wont_ing
yenning11369493yen_ning
zesting174515333zest_ing

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.423422437.4
2DLD Change Limit1461623867.11020557.2
3Display Results3863860.1732231.2
 (SQL Overall)1786913867.70623188.6
 
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.