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

304 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
centares10291389(None) 
centare93113701centare_
centiares1167651centiares
centres93817121cent_res
ceintures1136732ceintures
censures102211622censures
centals94317052centa_ls
centas85020702centa__s
centaurea1143502centaurea
centaureas1242692centaureas
centauries1245532centauries
centaurs1035732centaurs
centavos1344782centavos
centered112513522centered
centers94420602center_s
centeses1079442centeses
centiare1067202centiare_
centiles103615812centiles
centimes124012612centimes
centners1057242centners
centones10313662centones
centrals102712032centrals
centre84316642cent_re_
centred103411682cent_red
centuries11311332centuries
cetanes9315132ce_tanes
dentures9312452dentures
entases72816272_entases
entires71517782_entires
hectares1338852hectares
hektares1535812hektares
pentanes10316082pentanes
tentages91011042tentages
ventages12119772ventages
ventures11311492ventures
acetates102013063ace_tates
antres65021003_ant_res
benames112814603ben_ames
betakes134212523be_takes
bewares12313373be_wares
calentures1244603calentures
canapes111213083can_apes
canards10311203can_ards
canaries10318943can_aries
canewares1447363canewares
cantalas104013523cantalas
cantals93919573canta_ls
cantatas103410093cantatas
cantered113415983cantered
canters94827733canter_s
cantharis1447183cantharis
cantles94721413cant_les
cantors94620753cantor_s
cantraps12319113cantraps
canvases13349523canvases
captures1239443captures
cares77369183c___ares
carfares13310323carfares
cartages11313313cartages
caviares1337993caviares
ceases84427073ce__ases
cedars93312833ce_dar_s
ceinture1036313ceinture_
cellared11398793cellared
cellarer10317923cellarer
cellarers11236503cellarers
cellaret103713573cellaret
cellarets11246063cellarets
cellars93713693cellar_s
cenacles1238023cenacles
cenotaphs1642243cenotaphs
cenotes92814543cen_otes
censers94313903censer_s
censes83721803cen__ses
censored11197953censored
censors93611843censor_s
censure92310603censure_
censured11248913censured
censurer10228133censurer
censurers11256073censurers
censuses10187543censuses
centai84814783centa__i
cental84420963centa__l
centaur935783centa_ur
centauric1343593centauric
centaury1343953centaury
centavo1245103centa_vo
centenaries1346483centenaries
center84421413cent__er
centerless1245003centerless
centesis1058143centesis
centile94217183centile_
centime114513033centime_
centimos12507323centimos
centner946853cent_ner
centos85920463cent__os
centra84113883cent_r_a
central93114473cent_ral
centraler1146683centraler
centralest1247143centralest
centric11312403cent_ric
centrism1249643cent_rism
centrist10314863cent_rist
centrum1168603cent_rum
centrums1236913centrums
cents74730333cent___s
centums11398783cent_ums
centuples13134333centuples
century1237193centur_y
cerates95428253ce_rates
ceres75540013ce___res
certes84623083cert__es
cestas85018543cesta__s
cestodes1138203cestodes
cestuses1038083cestuses
cetane8315283ce_tane_
cetes75731103ce_t__es
chantages1546583chantages
chares115631803c__hares
cinctures1346063cinctures
clientages1342793clientages
clotures10299023clotures
coendures1245213coendures
coenures1048683coen_ures
compares143816433compares
concaves1538913concaves
condores113315643condores
conjures17119913conjures
contacts123215213contacts
contains10316533contains
contes84432913cont__es
contorts101112643contorts
contraries12711933contraries
contras93015623cont_ras
contuses10413453contuses
costards113510793costards
costars94218013costar_s
cottages113310493cottages
cottars94412243cottar_s
coutures10311993coutures
creatures1138413creatures
crenatures1245333crenatures
cultures10310153cultures
curares94916853c_urares
custards11338393custards
cuttages11297223cuttages
decares102818533de_cares
decentres12238523decent_res
deciares11510633deciares
declares11611313declares
dekares122710873de_kares
denars74621433den_ar_s
denatures1038123denatures
dentals83915393denta_ls
dentate8315153dentate_
dentated10411703dentated
dentines93418403dentines
denture8311893denture_
ecotages1136973ecotages
ectases92911673_ectases
edentates1046953edentates
enates64026433_en_ates
encages103313783_encages
encases93116053_encases
encores9315213_encores
endures83314603_endures
enfaces122110913_enfaces
engages92912493_engages
enlaces92313393_enlaces
enlarges946073_enlarges
enrages83114853_enrages
ensnares856893_ensnares
ensures73315903_ensures
entails7912823_entails
entasis73012573_entasis
entered82718883_entered
enterer72015633_enterer
enterers82214153_enterers
enters64425643_enter_s
entices91616333_entices
entire61617703_entire_
entraps9109763_entraps
entree61817883_ent_ree
entrees71813773_entrees
entries71523163_entries
enures63919713_en_ures
estates74520183_estates
etapes85415293_e_tapes
fanfares1436773fanfares
features11310333features
gendarmes1343923gendarmes
genitures1046123genitures
genres75515623gen__res
gentes75324163gent__es
gentiles93713523gentiles
gentles83714343gent_les
gentries91315263gentries
geotaxes1644743geotaxes
gestates93213733gestates
gestures9310013gestures
hectare1238463hectare_
hektare1435503hektare_
henbanes1336573henbanes
heptanes1339003heptanes
infares10313023_infares
intakes11310943_intakes
kantars11310033kantar_s
kentes105118653kent__es
lectures101310153lectures
leotards945303leotards
meltages1148243meltages
menaces112715523men_aces
menages103615393men_ages
mentalese1146323mentalese
mentees93214503ment_ees
mentored1138003mentored
mentors9314993mentor_s
metages102714973me_tages
metates92720013me_tates
metres85121563me_t_res
mintages111110513mintages
montages111412183montages
montanes101114523montanes
nares55544153__n_ares
nectaries1149813nectaries
nectars938463nectar_s
nontaxes1537853nontaxes
ovenwares1543973ovenwares
pectases122411193pectases
pectates122213953pectates
penates93321603pen_ates
pennames12287793pennames
pentacles1338773pentacles
pentads1039523penta_ds
pentane9415743pentane_
pentarch1544943pentarch
pentarchs1643933pentarchs
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
petards104311153pe_tards
qintars16268573qintar_s
redwares1239053redwares
renames92418053ren_ames
renatures939443renatures
rennases848983rennases
rentals74017473renta_ls
renters74224813renter_s
rentes65431193rent__es
rentiers83311763rentiers
restages92815773restages
restarts8310873restarts
restates83423433restates
restores85222993restores
retakes113718863re_takes
retapes93917423re_tapes
retards85015003re_tards
retaxes143615093re_taxes
retires74726213re_tires
sceptres1244993scept_res
seawares1139333seawares
sectaries11312243sectaries
senates73322613sen_ates
senhores112810993senhores
senores73218113sen_ores
sensates8511143sensates
sentries81318053sentries
septages1168263septages
snares65329033_sn_ares
stares66038753__stares
syntaxes1843633syntaxes
tantaras8269543tantaras
tares57456563___tares
teawares1148083teawares
tenaces92814513ten_aces
teniases838623teniases
tentacles1146713tentacles
tentage81010643tentage_
tentered96412103tentered
tenters73921103tenter_s
tenures7412013ten_ures
testates83615453testates
textures1597523textures
tinwares1137913tinwares
upstares10178583upstares
vantages12119023vantages
vendaces1457183vendaces
venires103012453ven_ires
ventage11109623ventage_
ventails1139823ventails
venters103717733venter_s
ventrals112910003ventrals
venture10311173venture_
ventured1238273ventured
venturer1137243venturer
venturers1245523venturers
venturis1138193venturis
vestures11311043vestures
vintages12118273vintages
wantages12109023wantages
welfares1445543welfares
wetwares1445953wetwares
yentas94614213yenta__s
yentes95517603yent__es

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 Limit1461623046.70321805.5
3Display Results3043040.1102763.6
 (SQL Overall)1786913047.23624694.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.