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

281 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
central9311447(None) 
cental84420961cent_al
centra84113881centra_
centrals102712031centrals
ventral103612171ventral
antral65719412_antral
benthal1247952benthal
cantal84122032cant_al
canthal12410052canthal
cantrap113310282cantrap
censual937662censual
centai84814782cent_ai
centals94317052cent_als
centare93113702centare
centas85020702cent_as
centraler1146682centraler
centrally1448892centrally
centre84316642centr_e
centred103411682centred
centres93817122centres
centric11312402centric
centrical1348352centrical
centrum1168602centrum
centurial1147952centurial
citral81113892c_itral
contra83314702contra_
contrail10410982contrail
contras93015622contras
control9310692control
dental74319172dent_al
dentural948082dentural
dextral1577002dextral
enteral73516442_enteral
enthral103410932_enthral
entrap8710562_entrap
estral64716512_estral
general81010932general
mental84521602ment_al
neutral737922neutral
peytral1287502peytral
rental63922022rent_al
retral64419742re_tral
sceptral1244512sceptral
ventrals112910002ventrals
vestral104111012vestral
accentual1343673accentual
acentric1247533acentric
acetal84314903ace_t_al
agential958153agential
ancestral1145183ancestral
antra56521923_antra_
anural65714743_anural
astral66919283_astral
austral73411513austral
benzal1739643ben_zal
bestial9311643bestial
betray111511443be_tray
cadential1246393cadential
caesural1055393caesural
caltrap11297943caltrap
cameral11311283cameral
canal75428043can__al
cantala94114673cant_ala
cantals93919573cant_als
cantonal1038903cantonal
cantorial1149803cantorial
cantraip12326393cantraip
cantraps12319113cantraps
cantrip112910043cantrip
caporal11410943caporal
cecal94619113ce__cal
censorial11117503censorial
cent67451013cent___
centares102913893centares
centaur935783centaur
centavo1245103centavo
center84421413cent_er
centered112513523centered
centers94420603centers
centiare1067203centiare
centigram1443983centigram
centile94217183centile
centime114513033centime
centimo11609543centimo
centner946853centner
cento76625173cent__o
centos85920463cent_os
centralest1247143centralest
centralise1269603centralise
centralism1448643centralism
centralist12511063centralist
centrality1547743centrality
centralize2149963centralize
centring112112953centring
centriole1145673centriole
centrism1249643centrism
centrist10314863centrist
centroid1159313centroid
centrums1236913centrums
cents74730333cent__s
centu76119413cent__u
centum104012363cent_um
centums11398783centums
centuple12164043centuple
century1237193century
ceorl7410913ce_or_l
ceramal1138843ceramal
cercal10314123ce_rcal
cereal8315833ce_real
cerebral1266183cerebral
cesta75419483cest_a_
cestas85018543cest_as
cesura838763cesura_
cesurae937703cesurae
cesuras958693cesuras
chiral114614413c_hiral
chital114313883chit_al
chloral12169983chloral
choral115118493c_horal
citrals91111673c_itrals
cliental1045353client_al
clitoral10106463clitoral
coital84117053coit_al
conceal113313013conceal
conchal144211583conchal
congeal104011683congeal
conical11316203conical
construal1146793construal
contract122915633contract
contrails11410543contrails
contralti1147743contralti
contralto1147093contralto
contrary1347493contrary
contrast102614783contrast
controls10311393controls
coral76033453c__oral
corral83616253c_orral
costal85419513cost_al
costrel9310373costrel
creatural1144903creatural
crestal9312133crest_al
crural8610633c_rural
cultural1047263cultural
cuneal8611513cun_eal
curtal83914543curt_al
cynical1437873cynical
denial74720513den_ial
dentals83915393dent_als
dentil74017883dent_il
dentinal939503dentinal
dextran1586163dextran
dicentra1145433dicentra_
dicentras1245473dicentras
engrail846263_engrail
engram9310653_engram
enrol51014283_en_rol
entail61114343_entail
entera64216833_entera_
enthrall11266833_enthrall
enthrals11278903_enthrals
entia5318203_entia_
entoil6912493_entoil
entrails8310163_entrails
entrain7313073_entrain
entrant7318873_entrant
entraps9109763_entraps
entreat7315263_entreat
entree61817883_entree
entry82414263_entr_y
enwrap1185213_enwrap
epicentral1454373epicentral
estray95713333_estray
estrual7367933_estrual
eventual1144883eventual
extra1239003_extra_
extras13310223_extras
federal1148533federal
femoral1238723femoral
fenestral1244113fenestral
feral85424653fe__ral
festal94213563fest_al
fetal85623373fe_t_al
fetial95716193fe_tial
fontal9313143font_al
funeral1037623funeral
gastral8329553gastral
genera71211713genera_
generals9109333generals
genial74917613gen_ial
genital849793genital
genteel836753genteel
gentian8310103gentian
gentil74115123gent_il
gentry103410443gentr_y
gestural946033gestural
inthral10249463_inthral
kestrel1137113kestrel
lentil64315393lent_il
lethal939803le_thal
lustral7339653lustral
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
meatal84114733meat_al
menial84223033men_ial
menorah1247933menorah
mensal84615653men_sal
menstrual1144353menstrual
mensural1046223mensural
menta74424423ment_a_
menthol1236723menthol
metal75427383me_t_al
mineral9312733mineral
mistral91013643mistral
mitral81314323_mitral
neural6311993ne_ural
neutrals846283neutrals
noncentral1248003noncentral
nonoral7313603nonoral
omental93210413oment_al
pectoral121210503pectoral
penal75228373pen__al
penial84120893pen_ial
pentad9313763pent_ad
pentyl1138813pent_yl
peroral9314793peroral
petal76526893pe_t_al
petrale9312623pe_trale
petrel83111533pe_trel
petrol82714063pe_trol
peytrals1355493peytrals
peytrel1264253peytrel
rectal84418133rect_al
renal55929503ren__al
renewal1038703renewal
rentals74017473rent_als
restoral8810983restoral
retial64724993re_tial
retrial7615553re_trial
rostral7311333rostral
scenical1247133scenical
sciential1146323sciential
sectoral10109543sectoral
sendal73314993sen_dal
senora63216153senora_
senoras72714953senoras
sensual738053sensual
sentry92912053sentr_y
septal84513383sept_al
seral56336383se__ral
setal56430903se_t_al
several1039533several
spectral12246193spectral
subcentral1453833subcentral
tantra63713353tantra_
tantras73112093tantras
tectal83713253tect_al
tendril836783tendril
tentorial9119603tentorial
tenurial847703tenurial
tertial7313863tertial
tetra53417953te_tra_
tetrad73612053te_trad
tetras63017623te_tras
tetryl935693te_tryl
textual1444603textual
textural1544943textural
venal85523213ven__al
venereal1145083venereal
venial94218283ven_ial
ventail10310453ventail
ventrally1547253ventrally
vestal94615573vest_al
vestural1156473vestural
xenial133414903xen_ial
yantra9449623yantra_
yantras10259003yantras
yenta83917043yent_a_
yentas94614213yent_as
zenithal2093333zenithal

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272817.04619021.7
3Display Results2812810.0933021.5
 (SQL Overall)1786912817.27924548.8
 
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.