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

410 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
centra8411388(None) 
central93114471central
centre84316641centre
contra83314701contra
antra56521922_antra
cantrap113310282cantrap
cent67451012cent__
centai84814782centai
cental84420962cental
centare93113702centare
centas85020702centas
center84421412center
centers94420602centers
cento76625172cent_o
centos85920462centos
centrals102712032centrals
centred103411682centred
centres93817122centres
centric11312402centric
centrum1168602centrum
cents74730332cent_s
centu76119412cent_u
centum104012362centum
century1237192century
cesta75419482cest_a
cesura838772cesura
contras93015622contras
dicentra1145432dicentra
entera64216832_entera
entia5318202_entia
entrap8710562_entrap
entry82414262_entry
extra1239002_extra
genera71211712genera
gentry103410442gentry
mantra84116092mantra
menta74424422ment_a
senora63216162senora
sentry92912052sentry
tantra63713362tantra
tetra53417952te_tra
ventral103612172ventral
yantra9449622yantra
yenta83917042yent_a
acantha1254663acantha
acentric1247543acentric
aceta74017353ace_t_a
agentry11165753agentry
amentia9310153amentia
anta46839583_ant_a
antral65719413_antral
antre55224523_antre
bent67759913bent__
benthal1247963benthal
bento75922953bent_o
bentos86218313bentos
bents76033693bent_s
bertha11429173bertha
beta66234133be_t_a
betray111511443be_tray
betta74916843be_tta
caesura956253caesura
caltrap11297943caltrap
camera10313693camera
canard9314763canard
canary11314693canary
cancha134411613cancha
caner75334773caner_
caners84629203caners
canna75919333can_na
canola8313623canola
cant66362033cant__
cantal84122033cantal
cantala94114673cantala
cantata93811813cantata
canted94825783canted
canter85230113canter
canters94827733canters
canthal12410053canthal
canthi11310973canthi
cantic103920543cantic
cantina93417253cantina
cantle84522153cantle
canto74931013cant_o
canton85722993canton
cantor85621523cantor
cantors94620753cantors
cantos84826973cantos
cantraip12326393cantraip
cantraps12319113cantraps
cantrip112910043cantrip
cants77036943cant_s
cantus85117763cantus
canty105226803cant_y
canula8312973canula
ceca84820783ce__ca
cedar84014323cedar_
cedarn9408443cedarn
cedars93312833cedars
cedary12419603cedary
ceder85322243ceder_
ceders93817673ceders
cedula977643cedula
ceiba938703ce_iba
ceinture1036313ceinture
celery1139623celery
cella75420313ce_lla
cellar84514983cellar
celt65646713celt__
celts75325783celt_s
cementa112810543cement_a
cenote83715843cenote
cenotes92814543cenotes
cense75121403cen_se
censed94016323censed
censer84516583censer
censers94313903censers
censes83721803censes
censor84011293censor
censors93611843censors
censual937663censual
censure92310603censure
census84310303census
centals94317053centals
centares102913893centares
centaur935783centaur
centaurea1143503centaurea
centaurs1035733centaurs
centaury1343953centaury
centavo1245103centavo
centered112513523centered
centiare1067203centiare
centigram1443983centigram
centile94217183centile
centime114513033centime
centimo11609543centimo
centner946853centner
centners1057243centners
centraler1146683centraler
centrally1448903centrally
centrical1348353centrical
centring112112953centring
centrism1249643centrism
centrist10314863centrist
centroid1159313centroid
centrums1236913centrums
centums11398783centums
centurial1147963centurial
ceorl7410923ce_orl
cere66741473ce__re
cerebra1155933cerebra
ceria75125363ce_ria
cero66329453ce__ro
certes84623083certes
cestas85018543cestas
cesti75217423cest_i
cestoi84511953cestoi
cestos84718093cestos
cestus84412913cestus
cesurae937703cesurae
cesuras958693cesuras
cete64934783ce_t_e
cetes75731103ce_tes
chakra15437533chakra
chantry15388223chantry
cinema1047653cinema
citral81113893c_itral
cnida878963c_nida
cobra95214403c_obra
coenure968153coenure
coenuri945463coenuri
concha134213283concha
conga85419873con_ga
conte76633203cont_e
contes84432913contes
conto76027173cont_o
contort91422343contort
contos84923233contos
contract122915633contract
contrail10410983contrail
contrary1347493contrary
contrast102614783contrast
control9310693control
coppra12306833coppra
copra98115463c_opra
costa75523733cost_a
costar85518613costar
cotta75818573c_otta
cottar84613813cottar
country12388043country
crura7312593c_rura
cuatro838433cuatro
cuesta838513cuest_a
cunt66243673cunt__
cunts76125123cunt_s
curara83712203curara
decentre11248553decentre
delta66117773delt_a
denar65223293denar_
denari710917353denari
denars74621433denars
denary105316863denary
dent57158413dent__
dental74319173dental
dented84120513dented
dentil74017883dentil
dentin73919573dentin
dents65031803dent_s
dentural948083dentural
denture8311893denture
dextral1577003dextral
dextran1586163dextran
dextro1436123dextro
dicentras1245473dicentras
elytra934893elytra
enema7612743_enema
engram9310653_engram
enorm74415643_enorm
enter54726383_enter
enteral73516453_enteral
enters64425643_enters
enthral103410933_enthral
entire61617703_entire
entrain7313073_entrain
entrant7318873_entrant
entraps9109763_entraps
entreat7315263_entreat
entree61817883_entree
enure53520223_enure
enwrap1185213_enwrap
epicentra1353653epicentra
era35741503_e__ra
estral64716513_estral
estray95713333_estray
eta35834193_e_t_a
etna46415263_e_tna
extras13310223_extras
eyra76217553_e_yra
fedora1038593fedora
femora1149583femora
fenestra1143553fenestra
feta76528903fe_t_a
gantry103810113gantry
general81010943general
geneva1085853geneva
genoa64315823gen_oa
genre66016803gen_re
genro64914033gen_ro
gent56954393gent__
gentes75324163gentes
gentian8310103gentian
gentil74115123gentil
gentle74014513gentle
gently103710913gently
gentoo7311313gentoo
gents65729613gent_s
genua64614153gen_ua
geta56627443ge_t_a
hegira1036523hegira
hejira1644803hejira
henna84414043hen_na
henry114014473hen_ry
hent76656383hent__
hented104218753hented
hents87330743hent_s
infra838643_infra
intro54915853_intro
junta123713673junt_a
kantar10311163kantar
kent86846983kent__
kente95821073kent_e
kentes105118653kentes
kinara10310373kinara
lent46360533lent__
lenten6312883lenten
lentic83515743lentic
lentil64315393lentil
lento57223393lent_o
lentos65317403lentos
lepta75714393lept_a
lustra6358893lustra
manta75629913mant_a
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mantua84412023mantua
megara9310093megara
menorah1247933menorah
mensa75318673men_sa
menstrua1044023menstrua
mental84521603mental
mentee84121293mentee
mentor8414363mentor
mentors9314993mentors
mentum104511713mentum
meta65932413me_t_a
metre74821303me_tre
metro74718803me_tro
nectar838853nectar
neutral737923neutral
olestra746173olestra
omenta83411723oment_a
osetra667423osetra
pantry115014103pantry
peltry11288653peltry
penna74520203pen_na
pennia84412973pennia
pent66559073pent__
pentad9313763pentad
pentyl1138813pentyl
penury1148103penury
peytral1287503peytral
pinta75727053pint_a
plectra1145793plectra
qintar15359143qintar
reata54225393reat_a
recta74220263rect_a
reentry1038033reentry
remora8414593remora
rent46661243rent__
rental63922033rental
rente54733783rent_e
rented74426593rented
renter64527413renter
renters74224823renters
rentes65431193rentes
rents55935183rent_s
retia55326113re_tia
retral64419743re_tral
retro55020953re_tro
retry84718083re_try
ristra6310713ristra
rostra6310933rostra
santera7311313santera
scena74815783scen__a
scenery1236563scenery
scent75831623scent__
scented102811893scented
scents85317023scent_s
sceptral1244513sceptral
sceptre1135053sceptre
senary93716073senary
seneca839793seneca
senega738173senega
senhora10348673senhora
senna54617983sen_na
senor53822803senor_
senoras72714953senoras
senors63620793senors
sensa54117473sen_sa
sent46963013sent__
sente56432883sent_e
senti56226703sent_i
septa75518083sept_a
sera46141393se__ra
seta45637313se_t_a
sistra639333sistra
spectra11275833spectra
sutra54217933_sutra
synura935983synura
tantara72410823tantara
tantras73112093tantras
tecta74215523tect_a
tenia55324483ten_ia
tenor53620253tenor_
tenors63217753tenors
tent46159863tent__
tented74221003tented
tenter64623933tenter
tenters73921113tenters
tenth85421833tent_h
tenths94412663tenths
tentie62521183tentie
tentoria8119283tentoria
tents56434213tent_s
tenty86121603tent_y
tenure6311613tenure
tephra1136483tephra
terra54419673te_rra
testa54822043test_a
tetrad73612053te_trad
tetras63017623te_tras
tetri52716453te_tri
tundra736423tundra
ultra539363_ultra
vena76126293ven__a
venery123710663venery
venire93513693venire
vent76049053vent__
vented104617923vented
venter94218723venter
venters103717733venters
ventrals112910003ventrals
vents86125933vent_s
venture10311173venture
venturi1037203venturi
vera76828843ve__ra
vesta86618303vest_a
vestral104111013vestral
vestry1238623vestry
went76051873went__
wintry12498923wintry
xenia124814773xen_ia
yantras10259003yantras
yentas94614213yentas
yente86220043yent_e
yentes95517603yentes
zebra1637883ze_bra
zenana15297983zenana
zeta135121643ze_t_a

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164105.12621989.1
3Display Results4104100.1402928.6
 (SQL Overall)1786914105.65631593.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.