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

337 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
centare9311370(None) 
centares102913891centares
centiare1067201centiare
centre84316641cent_re
ceinture1036312ceinture
censure92310602censure
centai84814782centa_i
cental84420962centa_l
centals94317052centals
centas85020702centa_s
centaur935782centaur
centaurea1143502centaurea
centaurs1035732centaurs
centaury1343952centaury
centavo1245102centavo
center84421412center_
centered112513522centered
centers94420602centers
centiares1167652centiares
centile94217182centile
centime114513032centime
centner946852centner
centra84113882cent_ra
central93114472central
centred103411682cent_red
centres93817122cent_res
century1237192century
cetane8315282ce_tane
dentate8315152dentate
denture8311892denture
entire61617702_entire
hectare1238462hectare
hektare1435502hektare
pentane9415742pentane
tentage81010642tentage
ventage11109622ventage
venture10311172venture
acetate92514753ace_tate
antae56828293_anta_e
antre55224523_ant_re
bename103316073ben_ame
betake124512703be_take
beware11313713be_ware
calenture1144303calenture
canape10913513can_ape
canard9314763can_ard
canary11314693can_ary
caneware1347803caneware
cantal84122033canta_l
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
canter85230113canter_
cantered113415983cantered
canters94827733canters
cantle84522153cant_le
cantor85621523cantor_
cantors94620753cantors
cantrap113310283cantrap
capture1138913capture
care66968373c___are
carfare12310073carfare
cartage10312593cartage
caviare1238373caviare
cease75227653ce__ase
cedar84014323ce_dar_
cedarn9408443ce_darn
cedars93312833ce_dars
cedary12419603ce_dary
ceintures1136733ceintures
cellae84915933cella_e
cellar84514983cellar_
cellared11398793cellared
cellarer10317923cellarer
cellaret103713573cellaret
cellars93713693cellars
cenacle1139123cenacle
cenotaph1542633cenotaph
cenote83715843cen_ote
cense75121403cen__se
censer84516583censer_
censers94313903censers
censor84011283censor_
censored11197953censored
censors93611833censors
censured11248913censured
censurer10228133censurer
censures102211623censures
cent67451013cent___
centaureas1242693centaureas
centauric1343593centauric
centauries1245523centauries
centavos1344783centavos
centenary1444323centenary
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
centimo11609543centimo
centners1057243centners
cento76625173cent__o
centones10313663centones
centos85920463cent_os
centraler1146683centraler
centrals102712033centrals
centric11312403centric
centrum1168603centrum
cents74730333cent__s
centu76119413cent__u
centum104012363cent_um
centums11398783centums
centuple12164043centuple
centuries11311333centuries
cerate84829463ce_rate
cere66741473ce___re
certain92612213certain
cesta75419483cesta__
cestas85018543cesta_s
cestode1037963cestode
cesurae937703cesurae
cetanes9315133ce_tanes
cete64934783ce_t__e
chantage1446633chantage
chare105231983c__hare
cincture1245583cincture
clientage1242713clientage
cloture9238453cloture
coendure1145463coendure
coenure968153coen_ure
compare135814993compare
concave1439373concave
conjure16109073conjure
connate9315753connate
contact1144020683contact
contain9315833contain
conte76633203cont__e
contort91422343contort
contra83314703cont_ra
contrary1347493contrary
contras93015623contras
contuse9311413contuse
costae85319683costa_e
costar85518613costar_
costard104113353costard
costars94218013costars
costate94019273costate
cottae84615703cotta_e
cottage104210573cottage
cottar84613813cottar_
cottars94412243cottars
couture9310623couture
creature1038723creature
crenate93317113cren_ate
crenature1145753crenature
culture939393culture
cuneate9311723cuneate
curare84916953c_urare
curtate9312643curtate
custard10389973custard
cuttage10318343cuttage
decare93919153de_care
decentre11248553decent_re
deciare10710663deciare
declare10411223declare
dekare112811563de_kare
denar65223293den_ar_
denari710917353den_ari
denars74621433den_ars
denary105316863den_ary
denature938063denature
dental74319173denta_l
dentals83915393dentals
dentated10411703dentated
dentine83320243dentine
dentures9312453dentures
ecotage1036883ecotage
edentate947703edentate
enate54428143_en_ate
encage93713503_encage
encase83714363_encase
encore8314773_encore
endure74014143_endure
enface112510353_enface
engage82812103_engage
enlace82213233_enlace
enlarge835533_enlarge
enrage72715073_enrage
ensnare767123_ensnare
ensure63416003_ensure
entail61114343_entail
entases72816273_entases
enter54726383_enter_
entera64216833_entera
entered82718883_entered
enterer72015633_enterer
enters64425643_enters
entice81316863_entice
entires71517783_entires
entrap8710563_entrap
entree61817883_entree
entry82414263_ent_ry
enure53520223_en_ure
estate64719763_estate
etape74413703_e_tape
fanfare1336673fanfare
feature1039853feature
gendarme1243523gendarme
geniture946453geniture
genre66016803gen__re
gentile83515293gentile
gentle74014513gent_le
gentler8378953gentler
gentry103410443gent_ry
gestate83614073gestate
gesture839243gesture
hectares1338853hectares
hektares1535813hektares
henbane1237353henbane
heptane1238363heptane
infare9313083_infare
intake10510863_intake
kantar10311153kantar_
kantars11310033kantars
kente95821063kent__e
lecture9149513lecture
leotard846193leotard
meltage1037953meltage
menace103216943men_ace
menage93216543men_age
mensae84114043mensa_e
menta74424423menta__
mental84521603menta_l
mentee84121293ment_ee
mentor8414363mentor_
mentored1138003mentored
mentors9314993mentors
metage93114453me_tage
metate82720533me_tate
metre74821303me_t_re
mintage101110123mintage
montage101211713montage
montane91313623montane
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
ovenware1444243ovenware
pectase112410363pectase
pectate112214693pectate
peltate92013773peltate
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pentacle1239383pentacle
pentad9313763penta_d
pentads1039523pentads
pentanes10316083pentanes
pentarch1544943pentarch
pentene9313793pentene
pentode1039893pentode
pentose9311593pentose
petard95013803pe_tard
qintar15359143qintar_
qintars16268573qintars
redware1139353redware
rename82718813ren_ame
renature839323renature
rennase738713rennase
rentable101716333rentable
rental63922023renta_l
rentals74017473rentals
rente54733783rent__e
renter64527413renter_
renters74224813renters
rentier73618223rentier
restage83316193restage
restart7320033restart
restate73824883restate
restore75822973restore
retake104718533re_take
retape83917683re_tape
retard75018933re_tard
retire64927013re_tire
retore67630763re_tore
sceptre1135043scept_re
seaware1049623seaware
sectary1238273sectary
senary93716073sen_ary
senate63725143sen_ate
sensate7311883sensate
sente56432873sent__e
sentry92912053sent_ry
septage1078403septage
septate9511873septate
setae56026223se_ta_e
snare54429983_sn_are
stare54440263__stare
tantara72410823tantara
tare45957623___tare
tartare73012683tartare
teaware1048143teaware
tenace82715693ten_ace
teniae64517353tenia_e
tentacle1037693tentacle
tentages91011043tentages
tenter64623933tenter_
tentered96412103tentered
tenters73921103tenters
tentie62521183tent_ie
tentier73815923tentier
tenure6311613ten_ure
testae64216253testa_e
testate73916233testate
texture1497083texture
tinware1038603tinware
untame82513603_untame
upstare9158683upstare
vantage11109893vantage
venae85920983ven_a_e
vendace1357363vendace
venire93513693ven_ire
ventages12119773ventages
ventail10310453ventail
venter94218723venter_
venters103717733venters
ventral103612173ventral
ventured1238273ventured
venturer1137243venturer
ventures11311493ventures
venturi1037203venturi
vesture10310373vesture
vintage11128143vintage
wantage11119623wantage
welfare1335713welfare
wetware1335793wetware
yenta83917043yenta__
yentas94614213yenta_s
yente86220043yent__e
zingare1737143zingare

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.1731032896.0
2DLD Change Limit1340273377.43618024.1
3Display Results3373370.1262674.6
 (SQL Overall)1786913377.73523101.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.