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

216 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
clavate123871(None) 
carate84734002c_arate
clavately1742612clavately
clave105420152clav__e
cleavage1442772cleavage
climate11312832climate
cravat11314442cravat_
cravats1237402cravats
cyanate12259702cyanate
elevate101110372elevate
lanate6421262_lanate
lavage1038262_lavage
placate11312432placate
planate9314572planate
savate9313782_savate
valvate133710812valvate
abate76627843__abate
acervate1336983acervate
activate13510373activate
agate66525153__agate
alate55340323__alate
aviate9315203__aviate
blate75933783bl__ate
bloviate1384913bloviate
calamata1247553calamata
calamite12312533calamite
calcarate1347703calcarate
calceate1239863calceate
calcite11413783calcite
califate13310483califate
calotte9510563calotte
calvary1537183calvary
calve105919923calv__e
calycate1537893calycate
canape10913513c_anape
capote10315733c_apote
carafe115416163c_arafe
carat75048793c_arat_
carates95630613c_arates
carats85929023c_arats
carte75940423c_a_rte
caseate9314783caseate
caste75932363c_a_ste
cate66254603c___ate
caudate10311353caudate
cavatine13310323c_avatine
cave95941263c_av__e
caveat11417723c_aveat_
caveated1439133c_aveated
caveats1239803c_aveats
caviare1238373c_aviare
cavie104621593c_av_ie
cavitate13159833c_avitate
cavity14310013c_avity
celibate1259313celibate
cellmate1237873cellmate
cerate84829463c_erate
chaetae1238603chaetae
chamade15138453chamade
chapati14118023chapati
charade13129913charade
chaste114617393cha_ste
chayote1536493chayote
chelate122914893chelate
chlorate133112693chlorate
cholate122114933cholate
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citrate
clade85821013cl__ade
cladode1134613cladode
clamant11312433clamant
clambake1843893clambake
clapt98027173cla_pt_
claque17338563cla_que
claret84026573claret_
clarets94111103clarets
clarity12310913clarity
claspt104513413claspt_
classmate1344863classmate
clast76030583cla_st_
clasts84817293cla_sts
clathrate1445343clathrate
clatter94014973cla_tter
clause84311503cla_use
clavation1447003clavation
claver113816973clav_er
clavered14187633clavered
clavers124314903clavers
claves115020063clav_es
clavi104912923clav__i
clavicle1543603clavicle
clavier1239173clavier
clavus11347353clav_us
clayware1643933clayware
cleat76335063cl_eat_
cleated103417843cl_eated
cleats84919313cl_eats
cleavable1644473cleavable
cleavages1542863cleavages
cleave114212513cl_eave
cleveite1343823cleveite
climates12311973climates
cloacae1145233cloaca_e
clodpate1344083clodpate
clove105619443clov__e
clypeate1543873clypeate
cognate10312203cognate
collate92919683collate
colocate12313443colocate
comate104124843c_omate
connate9315753connate
cordate10315223cordate
costate94019273costate
couvade1335063couvade
craniate10312563craniate
crate76537403c__rate
crave105626313crav__e
create85126383c_reate
cremate113816183cremate
crenate93317113crenate
cultivate1447083cultivate
cultrate10310873cultrate
cuneate9311723cuneate
curate85226243c_urate
curtate9312643curtate
cuspate1138233cuspate
cyanates13238433cyanates
cyanite122710763cyanite
cyclamate1843793cyclamate
dealate83617843dealate
dilatate947773dilatate
elate55335883el__ate
elevated12118293elevated
elevates111110423elevates
eluate62315433el_uate
eluviate1146953eluviate
emanate9312473emanate
excavate2045053excavate
falcate12311613falcate
flatmate1346393flatmate
flavine1338453flavine
flavone1335523flavone
galeate83916783galeate
gallate83417123gallate
gavage1137193_gavage
glabrate1146033glabrate
glaciate1168073glaciate
gladiate1057053gladiate
globate1057823globate
gradate9511233gradate
hamate113319833_hamate
imamate1138103imamate
karate105320923_karate
khanate1437073khanate
labiate91313573_labiate
lactate9312693_lactate
lanated8313203_lanated
larvae938843_larva_e
late47560483_l__ate
latte55426303_la_tte
lava76725423_lava__
lavabo1135273_lavabo
lavages1138603_lavages
lavas85422223_lava_s
lavash12597373_lavash
lave75642143_lav__e
legate72917453_legate
ligate72519253_ligate
lobate82915243_lobate
locate83919843_locate
lovage1037353_lovage
lovat8321043_lovat_
lovats939073_lovats
lunate6316043_lunate
luxate1338083_luxate
lyrate94112103_lyrate
lysate9388103_lysate
malate84624553_malate
maleate94117543maleate
nervate1039533nervate
obovate1235463obovate
oleate6318883ol_eate
ovate84214393__ovate
oxalate1457623oxalate
palate84226783_palate
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
pavane114113443_pavane
placated1338453placated
placater1238013placater
placates12311753placates
platane93112303platane
plate74635113pl__ate
playdate1465263playdate
playmate1566463playmate
plicate11314513plicate
plumate1149803plumate
private121513263private
ramate83921683_ramate
ravage1039303_ravage
salivate11310013salivate
salvage1138193salvage
savage10410173_savage
savates10312953_savates
slainte738543slainte
slate55438283sl__ate
slave84224033slav__e
solvate102710213solvate
ululate749963ululate
vacate11314553_vacate
vallate103016563vallate
valuate102512733valuate
volvate13317993volvate
vulvate13388323vulvate

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.406440125.6
2DLD Change Limit1340272166.75019855.9
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.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.