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

443 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
centals9431705(None) 
cantals93919571cantals
cental84420961cental_
centas85020701centa_s
centrals102712031centrals
dentals83915391dentals
rentals74017481rentals
acetals93411352ace_tals
canals84421672can_als
cantal84122032cantal_
cantala94114672cantala
cantalas104013522cantalas
centai84814782centa_i
centare93113702centare
centares102913892centares
centaur935782centaur
centaurs1035732centaurs
centavo1245102centavo
centavos1344782centavos
centers94420602centers
centile94217182centile
centiles103615812centiles
centos85920462cent_os
central93114472central_
centres93817122centres
cents74730332cent__s
centums11398782centums
cereals9313172cereals
cestas85018542cesta_s
curtals93111622curtals
denials84114132denials
dental74319172dental_
dentils84115582dentils
entails7912822_entails
genitals937242genitals
lentils73912972lentils
menials94015692menials
mental84521602mental_
metals84520892me_tals
pentads1039522pentads
pentyls1236522pentyls
petals84719812pe_tals
rental63922032rental_
sendals81912272sendals
ventails1139822ventails
ventrals112910002ventrals
vestals104612332vestals
yentas94614212yenta_s
abettals1054723abettals
acetal84314903ace_tal_
acetyls12285353ace_tyls
aerials74017553aerials
annals66415923_annals
anneals7449953anneals
annuals7388193annuals
antas55432033_anta_s
aventails1244993aventails
bantams1149063bantams
bendays13327513bendays
benthal1247963benthal_
benthos1238373benthos
bentos86218303bent_os
bents76033693bent__s
benzal1739643benzal_
benzols1836673benzols
benzyls2133673benzyls
betas75528763be_ta_s
betels84515063be_tels
bettas84913923betta_s
buttals938503buttals
cabals104020153c_abals
caftans12179443caftans
canal75428043can_al_
cancans11311873cancans
cancels114113313cancels
canfuls1248423canfuls
cannas84518403canna_s
cannels93413363cannels
canolas9313993canolas
cantata93811813cantata
cantatas103410093cantatas
canters94827733canters
canthal12410053canthal_
canthus1248713canthus
cantle84522153cant_le
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973cant_os
cantraps12319113cantraps
cants77036943cant__s
cantus85117763cant_us
canulas9312853canulas
canvas113813333canva_s
canvass12376873canvass
capitals12209453capitals
captans111612053captans
carpals113414633carpals
cartels94618123cartels
casuals91410533casuals
catalo8314853c_atalo
catalos9414163c_atalos
catnaps1197033catnaps
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
causals91411183causals
cecal94619113ce_cal_
cedars93312833ce_dars
cedulas1058503cedulas
ceibas1038503ceiba_s
ceils75019403ce__ils
celiacs11157893celiacs
cellars93713693cellars
cells75428063ce__lls
cels65534973ce___ls
celts75325783celt__s
cembali13156043cembali
cembalo13145533cembalo
cembalos14135163cembalos
cenacle1139123cenacle
cenacles1238023cenacles
cenotaph1542633cenotaph
cenotaphs1642243cenotaphs
cenotes92814543cenotes
censers94313903censers
censes83721803cen_ses
censors93611843censors
censual937663censual_
census84310303cen_sus
cent67451013cent___
centaury1343953centaury
center84421413cent_er
centeses1079443centeses
centesis1058143centesis
centiare1067203centiare
centiares1167653centiares
centime114513033centime
centimes124012613centimes
centimo11609543centimo
centimos12507323centimos
centner946853centner
centners1057243centners
cento76625173cent__o
centones10313663centones
centra84113883cent_ra
centraler1146683centraler
centralest1247143centralest
centralise1269603centralise
centralism1448643centralism
centralist12511063centralist
centrally1448903centrally
centre84316643cent_re
centred103411683centred
centric11312403centric
centrism1249643centrism
centrist10314863centrist
centrum1168603centrum
centrums1236913centrums
centu76119413cent__u
centum104012363cent_um
centuple12164043centuple
centuples13134333centuples
century1237193century
ceorls848163ce_orls
ceramals1246513ceramals
cerates95428253cerates
cercal10314123cercal_
cereal8315833cereal_
cerias83321983ceria_s
certain92612213certain
certes84623083cert_es
cesta75419483cesta__
cestos84718093cest_os
cestus84412913cest_us
cetane8315283ce_tane
cetanes9315133ce_tanes
cetes75731103ce_t_es
cheetahs1643783cheetahs
chetahs15347073chetahs
chital114313883chital_
chorals124614113chorals
cineols9128853cineols
citrals91111673citrals
cliental1045363cliental_
coals76129603c__oals
coequals1944313coequals
coevals1237883coevals
coital84117053coital_
conatus9310463conatus
conceals123111033conceals
confabs1435393confabs
congas94417033conga_s
congeals11309863congeals
consols92914073consols
consuls92412323consuls
contact1144020683contact
contacts123215213contacts
contain9315833contain
contains10316533contains
contes84432913cont_es
contos84923233cont_os
contrails11410543contrails
contras93015623contras
controls10311393controls
copals105018943c_opals
corals85325143c_orals
corrals93713853corrals
costal85419513costal_
costars94218013costars
cotans81317923c_otans
cottars94412243cottars
cottas84615573cotta_s
craals84113303c_raals
crenels93711013cren_els
crestal9312133crestal_
crystals1347173crystals
cuestas957933cuesta_s
cuneal8611513cuneal_
cunts76125123cunt__s
curtails10318243curtails
curtal83914543curtal_
cutlas8313103c_utlas
cymbals16236143cymbals
deals65435343de__als
decals93717713de_cals
deltas74414823delta_s
denars74621433den_ars
denial74720513denial_
dentalia947533dentalia
dentally121110063dentally
dentate8315153dentate
dentil74017883dentil_
dentins83419223dentins
dents65031803dent__s
details84214043de_tails
enates64026433_enates
enhalo987573_enhalo
enhalos1087533_enhalos
enols54718403_en_ols
enrols61213383_enrols
entail61114343_entail
entases72816273_entases
entasis73012573_entasis
enters64425643_enters
enthrals11278903_enthrals
entoils7810733_entoils
entrails8310163_entrails
entraps9109763_entraps
equals1538703_equals
etas46432273_e_ta_s
etnas54713933_etna_s
extols1337683_extols
fantails1139693fantails
fecials123510333fecials
fennels10387903fennels
fentanyls1541953fentanyls
ferals94216643fe_rals
festal94213563festal_
fetal85623373fe_tal_
fetas85624403fe_ta_s
fetials103711743fetials
finals94316163fin_als
finials103210153finials
fontal9313143fontal_
frontals1146273frontals
fungals11276783fungals
generals9109343generals
genial74917613genial_
genital849793genital_
genoas74013623genoa_s
gentes75324163gent_es
gentians937563gentians
gentil74115123gentil_
gentile83515293gentile
gentiles93713523gentiles
gentle74014513gent_le
gentles83714343gentles
gently103710913gent_ly
gentoos838633gentoos
gents65729613gent__s
gestalt8411173gestalt
gestalts955493gestalts
getas65421483ge_ta_s
gingals9109313gingals
hartals10313023hartals
heals85733463he__als
hennas94211803henna_s
hents87330743hent__s
heptads1335873heptads
herbals122710613herbals
instals7611713instals
jingals1588073jingals
juntas134210503junta_s
kantars11310033kantars
kenafs1337113ken_afs
kennels11387193kennels
kentes105118653kent_es
ketols104210763ke_tols
keypals1634353keypals
lanitals837723lanitals
legals73412733le_gals
lentil64315393lentil_
lentos65317403lent_os
lethals1038113lethals
lintels73311163lintels
lintols7339553lintols
mantas85725363manta_s
mantels94515043mantels
manuals9311223manuals
meals75933383me__als
meatal84114733meatal_
medals94218063me_dals
medials103914743medials
menads95514383men_ads
menial84223033menial_
mensal84615663mensal_
mensas85115863mensa_s
menta74424423menta__
mentalese1146323mentalese
mentalism13511643mentalism
mentalist11515553mentalist
mentally131010403mentally
mentees93214503mentees
menthols1347043menthols
mentors9314993mentors
mescals112911573mescals
metal75427383me_tal_
metols84115773me_tols
mezcals20246543mezcals
mortals93914013mortals
nectars938463nectars
neutrals846283neutrals
omental93210423omental_
orientals946923orientals
peals75235493pe__als
pedals94316033pe_dals
penal75228373pen_al_
penates93321603penates
pencels113610063pencels
pencils113011773pencils
penial84120893penial_
pensils92811593pensils
pentacle1239383pentacle
pentacles1338773pentacles
pentad9313763penta_d
pentane9415743pentane
pentanes10316083pentanes
pentanols1146113pentanols
pentyl1138813pentyl_
peptalk1554823peptalk
peptalks1653843peptalks
petal76526893pe_tal_
petnaps1145033petnaps
peytrals1355493peytrals
pineals93212853pineals
pintails10310163pintails
pintas85021393pinta_s
placentals1443523placentals
pontils9312213pontils
portals94015563portals
postals93716383postals
qintars16268573qintars
quintals17288003quintals
ratals64219583_ratals
reals55038653re__als
reatas64021013reata_s
recitals1039773recitals
recoals94214633recoals
rectal84418143rectal_
redials84416883redials
redtails968003redtails
refutals1165503refutals
renails74917263renails
renal55929513ren_al_
renewals1137283renewals
rentable101716333rentable
renters74224813renters
rentes65431193rent_es
rents55935183rent__s
repeals94014533repeals
reseals73917683reseals
retags73414303re_tags
retails74718973re_tails
retotals838463retotals
reveals103812733reveals
sandals82715203sandals
santols73513323santols
scandals1136993scandals
scenas84114703scen_a_s
scents85317023scent__s
seals54839703se__als
seitans73312303seitans
senates73322613senates
sendal73314993sendal_
sennas64214233senna_s
sepals85217383se_pals
septal84513383septal_
serials73919753serials
servals103410753servals
setal56430903se_tal_
sextans14349273sextans
spitals93011593spitals
suntans72111733suntans
tantalus836373tantalus
teals56234133te__als
tectal83713253tectal_
tenails73713923tenails
tenias64720073tenia_s
tentacle1037693tentacle
tentacles1146713tentacles
tentage81010643tentage
tentages91011043tentages
tenters73921103tenters
tenthly1335743tenthly
tenths94412663tent_hs
tents56434213tent__s
tepals85415043te_pals
tertials8510073tertials
tincals93610653tincals
totals63115163_totals
vandals113211663vandals
veals84926193ve__als
venal85523213ven_al_
venial94218283venial_
ventage11109623ventage
ventages12119773ventages
ventail10310453ventail
venters103717733venters
ventral103612173ventral_
vents86125933vent__s
verbals121910743verbals
vestal94615573vestal_
vestas95916683vesta_s
vinals94716483vin_als
vitals94514303_vitals
weals85428743we__als
xenial133414903xenial_
xenias133712973xenia_s
yenta83917043yenta__
yentes95517603yent_es
zeals145320853ze__als
zetas145018163ze_ta_s

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.826216332.9
2DLD Change Limit1340274436.89319443.9
3Display Results4434430.1702605.9
 (SQL Overall)1786914437.88922650.7
 
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.