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

173 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
conative13121462(None) 
donative12139871donative
coactive1598622coactive
cognitive1545482cognitive
combative1847212combative
conation101420882conation
conceive1539232conceive
connive1238992con_nive
constative15410102constative
contrive13311352contrive
costive12312842co_stive
creative132812802creative
curative13310402curative
donatives13146902donatives
locative1338682locative
monitive1349992monitive
native9613012__native
nonactive1448972nonactive
nonnative1248342nonnative
rotative11310342rotative
sanative11310472sanative
sonatine8313322sonatine
vocative1637912vocative
ablative1348243ablative
amative12311733_amative
calmative1647033calmative
canalise10816213canalise
canalize19914493canalize
captive1438973c_aptive
causative1445833causative
cavatine13310323cavatine
centile94217183cen_tile
centime114513033cen_time
coatee84327223co_at_ee
coati75624643co_ati__
coating103525313co_ating
coatis85122603co_ati_s
cobaltine13135613cobaltine
cobaltite13134333cobaltite
cocaine111315173coca_ine
coderive1447693coderive
codrive1337653co_drive
coercive1545873coercive
cogitative1645933cogitative
cognate10312203cognat__e
cognation12310753cognation
cohesive1646073cohesive
comate104124843comat__e
comatic131816933comati_c
comatik15139723comati_k
comatiks16148043comatiks
comatose1247823comatose
combinative2055133combinative
conations111318903conations
conatus9310463conat_us
concave1439373con_cave
conceived1746713conceived
conceiver1657413conceiver
conceives1639233conceives
conceptive1949513conceptive
conchie143312683conchi_e
concise11314473con_cise
conclave1556403conclave
concoctive1646803concoctive
conducive1745283conducive
conductive1848143conductive
confide13310203con_fide
confine12315583con_fine
confutative1955443confutative
congestive1647613congestive
coniine9316803con_iine
conine84528553con__ine
connate9315753connat__e
connation11314263connation
connective1749253connective
connived1436433con_nived
conniver1337493con_niver
connives1339723con_nives
connotative1665383connotative
conserve1339923conserve
conspire1257873conspire
constatives1646933constatives
construe1049053construe
consultive1546673consultive
contain9315833contai_n
contained12310893contained
container11311073container
contains10316533contains
conte76633203con_t__e
continue10311123con_tinue
contortive1546843contortive
contractive1849523contractive
contrastive1647293contrastive
contrite10318543contrite
contrived1547993contrived
contriver1448343contriver
contrives14311703contrives
contuse9311413con_tuse
contusive1445783contusive
convective2049113convective
convolve1644653convolve
coontie9311423coonti_e
cootie84223093co_oti_e
copulative1747293copulative
corrasive1445063corrasive
creatine103417413creatine
creatives14279693creatives
cunctative1744503cunctative
curatives1437823curatives
dative10311813__dative
decorative1648923decorative
denotive1238673denotive
detonative1447133detonative
dilative1239523dilative
dominative1677393dominative
donate73619503donat__e
donating10311803donating
donation91513783donation
durative1239073durative
elative10312453_elative
emanative1447313emanative
enactive1338513_enactive
ergative1238973ergative
evocative1746293evocative
fixative2145083fixative
formative1747963formative
genitive1247643genitive
hortative1546433hortative
ideative1238573ideative
illative1147183illative
inactive1348203_inactive
laxative1845093laxative
lenitive1148493lenitive
ligative1258803ligative
locatives1446563locatives
longtime1144363longtime
monazite1957083monazite
monetise10311473monetise
monetize1949983monetize
motive113112143mo__tive
mutative1348283mutative
naive85116213__na_ive
natives10310823__natives
negative1239083negative
nominative1597683nominative
nonnatives1345643nonnatives
normative1448893normative
onetime937623_onetime
optative1347653optative
pontine92419053pon_tine
portative1449373portative
positive1349993positive
probative1649173probative
punitive1346833punitive
putative1348373putative
relative11313143relative
sedative1238853sedative
sonatina849073sonatina
sorptive1346473sorptive
stative102612933_stative
tentative1247813tentative
tontine72316143ton_tine
unitive10310563_unitive
urinative1247653urinative
violative1545113violative
vocatives1745883vocatives
volatile1146433volatile
volitive1446893volitive
vomitive1645853vomitive
votive12348933vo__tive
zonate154114923zonat__e
zonation171410723zonation
zonetime1944953zonetime

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.406440125.6
2DLD Change Limit1461621737.28020077.2
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.76623009.4
 
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.